Skip to content

Registered aircraft · 20,683

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:90-06-03-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1') 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:90-06-03-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
  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:90-06-03-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
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.

N2758Panair Flying Club Inc · Miami, FLBuilt 1975 · S/N 17265168 N275AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2014 · S/N 172S11442 N275GTPs N275gt LLC · Green Bay, WIBuilt 1978 · S/N 17271631 N275PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2007 · S/N 172S10515 N275TXQualitair LLC Trustee · MichelstadtBuilt 2015 · S/N 172S11635 N2760UAnderson Justin Charles · Rockingham, NCS/N 17250360 N2761LMiller David L · Mineral City, OHBuilt 1967 · S/N 17255961 N2761UShafer Luke M · Wyoming, ILBuilt 1963 · S/N 17250361 N2762LRock Communications · Rock Hill, SCBuilt 1967 · S/N 17255962 N2762UCapozzi Rocky P · Eagle River, AKBuilt 1963 · S/N 17250362 N2763LTrent David A · Davin, WVBuilt 1967 · S/N 17255963 N2763UKnutson Wayne R · Tioga, NDBuilt 1963 · S/N 17250363 N2764UWells Dave · Nampa, IDBuilt 1963 · S/N 17250364 N2767LGay David B · Citronelle, ALBuilt 1967 · S/N 17255967 N2767UFisher James S · Texarkana, TXBuilt 1963 · S/N 17250367 N2768LJoseph Gary L · Ludlow, VTBuilt 1967 · S/N 17255968 N2769LRedditt Brian W · Columbia Station, OHBuilt 1967 · S/N 17255969 N2769UMckinney Edward L · Candler, NCFirst renewal noticeBuilt 1963 · S/N 17250369 N2769ZPacheco Ricardo · Albuquerque, NMBuilt 1956 · S/N 29077 N276GTChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9281 N276SALiberty University · Lynchburg, VABuilt 2013 · S/N 172S11276 N2770UStandard Equipment Leasing And Sales LLC · Wilmington, DEBuilt 1963 · S/N 17250370 N2771LP&N Corp · Marion, IABuilt 1967 · S/N 17255971 N2771UTobin Eric L · Cambridge, OHBuilt 1963 · S/N 17250371 N2772Lewis University · Romeoville, ILBuilt 2005 · S/N 17281252 N2772LBell William E Jr · Summerville, SCBuilt 1967 · S/N 17255972 N2774JPerez Guillermo · Castaic, CABuilt 1979 · S/N 17273649 N2775EFaulkner Harry E Jr · Bethel, AKBuilt 1978 · S/N 17271316 N2775LKing Mons A · Paoli, PABuilt 1967 · S/N 17255975 N2775RMiller David · Tyler, TXBuilt 1980 · S/N 172RG0624 N2775ULuff John W · Odessa, MOBuilt 1963 · S/N 17250375 N2776EAugusta Flying Club Inc · Martinez, GABuilt 1978 · S/N 17271317 N2776LRd Aire LLC · Opelika, ALBuilt 1967 · S/N 17255976 N2776UGarrison Randy · Queen City, TXBuilt 1963 · S/N 17250376 N2777ETop Flight Aviation Inc · Corona, CABuilt 1974 · S/N 17262885 N2777LHataway Gregory L · Kinston, ALBuilt 1967 · S/N 17255977 N2777TAviator Air Flight School LLC · Grand Prairie, TXBuilt 1972 · S/N 17261147 N2778URoberts Kenneth B · Wall Township, NJBuilt 1963 · S/N 17250378 N2779LResetar Douglas J · Pittsford, NYBuilt 1967 · S/N 17255979 N277CBN277cb LLC · Jacksonville, FLBuilt 1976 · S/N 17267516 N277GTSvetfur Aviation LLC · Camden, SCBuilt 2002 · S/N 172S9286 N277NWindh Randall · Reedley, CAS/N 28440 N277SLCharlies Wings LLC · Salisbury, NCBuilt 1973 · S/N 17261652 N27808St George Flight Academy LLC · St George, UTBuilt 1971 · S/N 17260023 N2782LSouthern Seaplane Inc · Belle Chasse, LABuilt 1967 · S/N 17255982 N2782UFrazier Doris C · Keller, TXBuilt 1963 · S/N 17250382 N2784UCobb Robert · Elberton, GAS/N 17250384 N2785UN2785u LLC · Hilton, NYBuilt 1963 · S/N 17250385 N2786UBoos Daniel Paul · Jackson, WYBuilt 1963 · S/N 17250386 N2787LGateway Flying Club Inc · Saint Louis, MOBuilt 1967 · S/N 17255987

Back to AD 90-06-03 R1