Skip to content

Registered aircraft · 83

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2011-02-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-02-08') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2011-02-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-02-08')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2011-02-08')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-02-08')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N101LELogan Air Services LLC · Logan, UTBuilt 1990 · S/N 907601 N106LWCross Counrty Soaring LLC · Brookfield, WIBuilt 1993 · S/N 938106 N10BRSale Reported · Peoria, ILSale reportedBuilt 1991 · S/N 917826 N118BBFranconia Soaring Association · Franconia, NHS/N 938026 N231LSSale Reported · Jefferson, GASale reported, pending cancellationBuilt 1993 · S/N 938020 N235STGreater Houston Soaring Association · Needville, TXS/N 988412 N251BAWillamette Valley Soaring Club · Cornelius, ORBuilt 1991 · S/N 917817 N256BAWillamette Valley Soaring Club · Cornelius, ORBuilt 1992 · S/N 917926 N257BASeminole Flying & Soaring Inc · Clermont, FLBuilt 1992 · S/N 917928 N258BAOmaha Soaring Club Inc · Omaha, NES/N 938018 N259BABlack Forest Soaring Society Inc · Monument, COS/N 938014 N262BAL23 LLC · Raleigh, NCBuilt 1993 · S/N 938019 N264BAEvergreen Soaring Inc · Lynnwood, WABuilt 1993 · S/N 938021 N265BAEvergreen Soaring Inc · Lynnwood, WABuilt 1993 · S/N 938024 N267BATcoag1 LLC · Maple Park, ILBuilt 1993 · S/N 938025 N270BAMudd Robert J · Moriarty, NMBuilt 1993 · S/N 938027 N271BAGreater Houston Soaring Association · Needville, TXBuilt 1994 · S/N 948112 N274BAGreater Houston Soaring Association · Needville, TXBuilt 1994 · S/N 948113 N276BAFowler Larry K · Harrison, ARBuilt 1994 · S/N 948115 N290SBSeminole Flying & Soaring Inc · Clermont, FLS/N 938029 N293BACentral Alabama Soaring Association · Birmingham, ALBuilt 1994 · S/N 948122 N294BAHinckley David D DBA · Belton, TXBuilt 1994 · S/N 948121 N299BALas Vegas Valley Soaring Association Inc · Jean, NVBuilt 1996 · S/N 968303 N303BAPost Mills Soaring Club · Lyme, NHBuilt 1996 · S/N 968216 N304MGUnusual Attitudes Inc · Homestead, FLS/N 917927 N305MGN305mg LLC · Homestead, FLBuilt 1992 · S/N 917930 N306BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 968304 N309BAFriends Aviation Inc · Wilmington, DEBuilt 1997 · S/N 978404 N316BABrandywine Soaring Assoc · Hockessin, DEBuilt 1999 · S/N 998416 N323SBRed Wing Soaring Assoc · Osceola, WIBuilt 1991 · S/N 917917 N325JHChristensen Douglas L · Grants Pass, ORBuilt 1991 · S/N 917910 N335BACivil Air Patrol Inc · Maxwell Afb, ALS/N 988410 N341BAVan Noy Terry W · Henderson, NVBuilt 1999 · S/N 998415 N352BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 998419 N357BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 998319 N358BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 998320 N360BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 998701 N361BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 2000 · S/N 008703 N362BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 2000 · S/N 008704 N363BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 2000 · S/N 008705 N364BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 2000 · S/N 008706 N366BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 2000 · S/N 008708 N367BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 2000 · S/N 008709 N371BACivil Air Patrol Inc · Maxwell Afb, ALS/N 008710 N372BASoaring Thunderbirds Inc · Canton, OHBuilt 2000 · S/N 008712 N373BAGreater Boston Soring Club · Sterling, MABuilt 2000 · S/N 008713 N383BATampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 2000 · S/N 008714 N387BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 2001 · S/N 018802 N389BAHolder Robert W · Pittsfield, PABuilt 2001 · S/N 018803 N393BANorth Florida Soaring Society Inc · Jacksonville, FLBuilt 2001 · S/N 019001

Back to AD 2011-02-08