Registered aircraft · 40,394

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

N9880QAircraft Resource Center Inc · Lakeville, MNBuilt 1975 · S/N 17265824 N9880WJuhl Aaron · Overland Park, KSBuilt 1967 · S/N 28-23400 N9880YMerrick Shane · Redgranite, WIBuilt 1961 · S/N 7GCB-73 N98811Kadena Aero Club · Apo Ap, CABuilt 1985 · S/N 17276359 N98819Oxford Flying Club Inc · Oxford, CTBuilt 1985 · S/N 17276362 N9881GFortenberry Robert N · Pascagoula, MSBuilt 1971 · S/N 17259781 N9881KHickman David R · Port Orange, FLBuilt 1977 · S/N 28-7890192 N9881QSky Drivers LLC · Lavalette, WVFirst renewal noticeBuilt 1975 · S/N 17265825 N9881UChristensen Myra J Storms · Pierre, SDBuilt 1976 · S/N AA5A0281 N9881VShackleford Developments Of Sc LLC · Mount Pleasant, SCBuilt 1974 · S/N 17264544 N98824Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276363 N9882DUsda Aphis Ws Atoc · Cedar City, UTBuilt 1959 · S/N 18-6904 N9882UNordbye Newell · Eden Prairie, MNBuilt 1976 · S/N AA5A0282 N9883GLagor Mark D · Parshall, NDBuilt 1971 · S/N 17259783 N98843American Patrols Inc · Midland, TXBuilt 1985 · S/N 17276367 N9884DMartensen Marten · Anchorage, AKS/N 18-6905 N9884GBarbour John P · Dexter, MOBuilt 1971 · S/N 17259784 N9884PVandegriff Cody E · Eagle River, AKBuilt 1976 · S/N 18-7709007 N9884VShockley James F · Loves Park, ILBuilt 1974 · S/N 17264546 N9884YRoberts Colton C · Bluebell, UTS/N 7GCB-119 N98851Jacques Jerry Joseph · Iliamna, AKS/N 18-7188 N9885DBarney Jeff S · Fairbanks, AKS/N 18-6907 N9885PTriple Cub Aviation LLC · Greenbush, MIBuilt 1976 · S/N 18-7709008 N9885QAngel Aviation Inc · Peoria, AZBuilt 1975 · S/N 17265829 N9885USchneider Fred M Jr · Fishkill, NYBuilt 1977 · S/N AA5A0285 N9885VNix Jacob DBA · Johnson, KSBuilt 1974 · S/N 17264547 N9885YCentral Air Parts Inc · Staunton, ILS/N 145 N9886KSmart03 LLC · Kissimmee, FLBuilt 1977 · S/N 28-7816205 N9886NHall Benton G · Plano, TXBuilt 1994 · S/N 2230 N9886VBognar John W III · Sardinia, NYBuilt 1974 · S/N 17264548 N9886WLathem Emma K · Amarillo, TXS/N 28-23406 N98873Laguna Verde Leasing Inc · Wilmington, DEFirst renewal noticeBuilt 1985 · S/N 17276369 N9887DRegistered aircraftBuilt 1959 · S/N 18-6911 N9887LSkywarrior Flight Training Inc · Pensacola, FLBuilt 1986 · S/N 17276645 N9887QTupelo Aeronautics Inc · Tupelo, MSS/N 17265831 N9887VDarby Holly M · Midland, TXBuilt 1974 · S/N 17264549 N98887Jodkin Jason · Confluence, PABuilt 1985 · S/N 17276373 N9888GRegistration Pending · Atlanta, TXRegistration pending, pending cancellationBuilt 1971 · S/N 17259788 N9888WSchlafer Antone · Lincoln, CABuilt 1967 · S/N 28-23408 N98893Pape Jason C · Sykesville, MDBuilt 1985 · S/N 17276374 N9889DBorth Johnny D · Meade, KSBuilt 1959 · S/N 18-6914 N9889GWright Flight Inc · Tucson, AZBuilt 1971 · S/N 17259789 N9889QTack-Morse Patricia M · Sweet Home, ORBuilt 1975 · S/N 17265833 N9889WFaix James M · Sarasota, FLBuilt 1967 · S/N 28-23409 N988BBForbes Donald L · Central Point, ORS/N BB1 N988BGMojo Flight Group LLC · Gainesville, GABuilt 1975 · S/N 17265795 N988JFMcdaniel Patrick D · State College, PABuilt 1999 · S/N 2843287 N988MSLong Mark A · Stanton, MIBuilt 1988 · S/N 11058C N988NADion William J · Coupeville, WABuilt 2006 · S/N 2088 N988TSFerrand Kathy · Cornelia, GABuilt 2001 · S/N 90251

Back to AD 79-10-03 R2