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.

N2896QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17259896 N2897LBork Joseph L · Mosier, ORS/N 17256097 N289JKFlightpath Aviation Services Inc · Brooksville, FLBuilt 1976 · S/N 17267701 N289JSJet Air Inc · Iowa City, IABuilt 2001 · S/N 172S8996 N28FACivil Air Patrol · Maxwell Afb, ALBuilt 1980 · S/N 17274208 N28HAHonaker Group LLC · Sellersburg, INBuilt 1978 · S/N 17271942 N28MKAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13269 N28PKAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13253 N28RJMisch Keith · Bayonne, NJS/N 172RG0869 N28SMMississippi Forestry Commission · Pearl, MSBuilt 1981 · S/N 17274744 N28WJAerinova Inc · Mattoon, ILBuilt 1978 · S/N 17270054 N29001Geske Sales & Service · Enderlin, NDBuilt 1974 · S/N 17264092 N29006Fancy Inc · Iowa City, IABuilt 1974 · S/N 17264093 N2900ECentaurus LLC · Ontario, CABuilt 1978 · S/N 17271368 N2901UJanes Charles D · Cleburne, TXS/N 17250501 N29028Service Oriented Aviation Readiness (Soar) · Bolivar, MOBuilt 1974 · S/N 17264095 N29047State College Pilots Club · Philipsburg, PABuilt 1974 · S/N 17264096 N29056Land Of Lakes Aviation LLC · Eagle River, WIBuilt 1974 · S/N 17264097 N2905ECappadona Roy · Iliamna, AKBuilt 1978 · S/N 17271369 N2905UKear Edward B · Bonita Springs, FLBuilt 1963 · S/N 17250505 N2906ULynch Lawrence C · Ladson, SCBuilt 1963 · S/N 17250506 N2907UServer William F · Sterling, MIBuilt 1963 · S/N 17250507 N290FGTextron Aviation Inc · Wichita, KSS/N 172S13638 N290PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2022 · S/N 172S12864 N290TWChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 172S9020 N290UOhio University · Albany, OHBuilt 2000 · S/N 172S8551 N29107Wrong Brothers Aviation LLC · Brighton, MIBuilt 1974 · S/N 17264100 N2911UNight Sky LLC · Canton, SDBuilt 1963 · S/N 17250511 N2913EG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17271371 N2914USethi Inderdeep S · Tracy, CABuilt 1963 · S/N 17250514 N29159Southridge Developments Inc · San Miguel, CAFirst renewal noticeBuilt 1974 · S/N 17264103 N29160Felber Dave A · Florissant, MOBuilt 1974 · S/N 17264104 N29168Galer Michael J Jr · Lockwood, MOBuilt 1974 · S/N 17264105 N2916UJohnson Mark D · Camano Island, WABuilt 1963 · S/N 17250516 N2917UCelebrate Freedom Foundation · West Columbia, SCS/N 17250517 N2918EDelpenn Flyers Inc · Dover, DEBuilt 1978 · S/N 17271372 N291ECElizabeth City State University · Elizabeth City, NCBuilt 2021 · S/N 172S12646 N291HWMiddle Village Enterprises LLC · Maspeth, NYBuilt 2012 · S/N 172S11239 N291KFTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 1972 · S/N 17260482 N291MEUnique Educational Experiences · Long Beach, CABuilt 2000 · S/N 172S8550 N291PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2022 · S/N 172S12865 N291RPGtr Aero LLC · Moultonborough, NHBuilt 1981 · S/N 17274327 N291TFTextron Aviation Inc · Wichita, KSS/N 172S13609 N291YASherman Jason Bradley · Indianola, IABuilt 1956 · S/N 28164 N2920UOtto Mark A · Ludington, MIBuilt 1963 · S/N 17250520 N29239Gibson Aviation Services LLC · Hudson, WIBuilt 1974 · S/N 17264108 N2923UWeber James · Fall Creek, WIBuilt 1963 · S/N 17250523 N29251Southeast Aviation Services Inc · Hattiesburg, MSBuilt 1974 · S/N 17264110 N2927ESchafer Thomas Charles · Caledonia, MOBuilt 1978 · S/N 17271374 N2927UCarlson Brent A · Medford, ORBuilt 1963 · S/N 17250527

Back to AD 90-06-03 R1