Skip to content

Registered aircraft · 25,368

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N9924QMy Way Aviation LLC · Weston, FLBuilt 1975 · S/N 17265868 N9924VEdwards Kevin M · Grass Valley, CAS/N 17264558 N99253Mitiguy Aviation LLC · Stow, MABuilt 1985 · S/N 17276421 N9925HScientific Aerial Imaging Inc · Saint Helena, CABuilt 1981 · S/N 18268117 N9925QRoeder Cara R · Lake Charles, LABuilt 1975 · S/N 17265869 N9925VGoodin Joshua W · Jacksonville, FLBuilt 1974 · S/N 17264559 N99263Wings Over Texas Holdings LLC · Denton, TXBuilt 1985 · S/N 17276424 N99265St Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1985 · S/N 17276425 N9926NBelchak Timothy A · Albuquerque, NMS/N 21063252 N99273United States Air Force · Dover Afb, DEBuilt 1985 · S/N 17276427 N9927QAndrus Shane · Pullman, WABuilt 1975 · S/N 17265871 N9928QDavis John · Jackson, WYBuilt 1975 · S/N 17265872 N9928YEckelkamp L B Jr · Washington, MOBuilt 1982 · S/N 21064643 N99295Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1985 · S/N 17276429 N992GCorbett Joshua J · La Canada, CABuilt 1964 · S/N 473 N992PSProctor Gary · Wichita, KSBuilt 1978 · S/N 21063074 N9930SGpm Flyers LLC · Colleyville, TXBuilt 1982 · S/N 24-1347 N9931BLevin Lawrence W · Glencoe, ILFirst renewal noticeBuilt 1982 · S/N 172RG1084 N9931EN9931e LLC · Phoenix, AZBuilt 1979 · S/N 17272291 N9931QDexter Aero Club Inc · Stetson, MEBuilt 1975 · S/N 17265875 N99329Tactical Integrated Training Soluctions LLC · San Antonio, TXBuilt 1985 · S/N 17276432 N9932SNeboschick Ashley B · North Charleston, SCBuilt 1981 · S/N 24-1096 N99338Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276433 N99341Jlinn Aviation Inc · Quinlan, TXBuilt 1985 · S/N 17276434 N99344Global Tours & Travel Services LLC · Davie, FLS/N 17276435 N99347Skywarrior Flight Training Inc · Pensacola, FLBuilt 1985 · S/N 17276436 N9934QDoupe Services LLC · Fort Myers, FLBuilt 1975 · S/N 17265878 N9935VD & S Aviation LLC · Wilmington, DEBuilt 1974 · S/N 17264562 N9936QHunt Richard M · Columbus, OHBuilt 1975 · S/N 17265880 N9936VLeading Edge Flight Academy LLC · Bend, ORBuilt 1974 · S/N 17264563 N99377Barta Terry · Faribault, MNBuilt 1985 · S/N 17276439 N9937E7 And 7 LLC · Leon, IABuilt 1979 · S/N 17272293 N9937QFosmo Richard E · Eatonville, WABuilt 1975 · S/N 17265881 N99396Flightline Air Service LLC · Pineville, LABuilt 1985 · S/N 17276441 N9939HVawter Russell R Trustee · Nampa, IDBuilt 1981 · S/N 18268128 N993JBLarson John H Trustee · Bend, ORBuilt 1993 · S/N 24-3297 N993SRThree S Ranch Inc · Blanca, COBuilt 1980 · S/N P21000477 N9940VSoco Aero Leasing LLC · Santa Rosa, CABuilt 1974 · S/N 17264566 N9942QWarren John Russell · Los Alamos, NMBuilt 1975 · S/N 17265886 N9943ELerud Peder E · Stockton, CABuilt 1979 · S/N 17272294 N9943QGrove Todd M · Lake Stevens, WABuilt 1976 · S/N 17265887 N99442Sale Reported · Kissimmee, FLSale reported, pending cancellationS/N 17276447 N9944QSkywarrior Flight Training Inc · Pensacola, FLBuilt 1975 · S/N 17265888 N9945EWilcox John C · Aurora, NEBuilt 1979 · S/N 17272295 N9945QClassic Air Aviation LLC · Mesa, AZBuilt 1975 · S/N 17265889 N99465Farzam Hamid · Newington, CTBuilt 1985 · S/N 17276450 N99467Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276451 N9946QHorizon Aviation LLC · Sinclair, MEBuilt 1975 · S/N 17265890 N9947CLoftin Aviation Group LLC · Suwanee, GABuilt 1978 · S/N R18200489 N994CDNavair LLC · Mount Vernon, OHBuilt 1979 · S/N 21063312

Back to AD 80-25-07 R1