Skip to content

Registered aircraft · 17,027

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

N5702GRandolph-Graham Monica L · Roanoke, TXBuilt 1969 · S/N 15071202 N5705RRucker David G · New Waverly, TXBuilt 1965 · S/N 17253359 N5706JTaylor Larry D · Meridian, IDBuilt 1969 · S/N P20600606 N5706RGraham Charles Arbe · Dexter, MIBuilt 1963 · S/N 18254793 N5707RIoele Brian · West Henrietta, NYBuilt 1965 · S/N 17253362 N5709RNick Monsen Trucking Inc · Buffalo Center, IABuilt 1965 · S/N 17253366 N570UABohl Howard M · Temecula, CAS/N 15067929 N5710RMarshall Fred R · Tulsa, OKBuilt 1965 · S/N 17253367 N5712JFree Air LLC · Helena, MTBuilt 1969 · S/N P20600612 N5712RGlobal Learning Solutions Inc · Montrose, COBuilt 1965 · S/N 17253370 N5713RAirspeed Marketing LLC · Phoenix, AZBuilt 1965 · S/N 17253372 N5715RBingham David · Marked Tree, ARBuilt 1963 · S/N 18254794 N5716JTaos Sky Flight School LLC · El Prado, NMBuilt 1969 · S/N P20600616 N5716RUdenburg Scott M · Cotter, ARBuilt 1965 · S/N 17253378 N5718GSwietek Robert E · Grand Rapids, MIBuilt 1969 · S/N 15071218 N5719RProfessional Aviation Aircraft Services Ltd · New Philadelphia, OHBuilt 1965 · S/N 17253383 N571VHVan Hoy Jeffrey D · Knightstown, INBuilt 1965 · S/N 15062392 N5722GSchmitt Rudy · Bulverde, TXBuilt 1969 · S/N 15071222 N5722RCalhoun Barry R · Richardson, TXBuilt 1965 · S/N 17253387 N5723RCoffey Bryan K · Anchorage, AKBuilt 1965 · S/N 17253389 N5724GCrnic John F · Kirksville, MOBuilt 1969 · S/N 15071224 N5724RMartindale Bryan T · Springfield, ILBuilt 1965 · S/N 17253393 N5727RBiederman Scott · Pompano Beach, FLS/N 17253396 N5729RMarreno Eddie J · Green Cove Springs, FLS/N 17253398 N572GSickles James D · Caledonia, NYBuilt 1969 · S/N 18259932 N5731JPaulick Adam J · Deerfield, WIBuilt 1969 · S/N P20600631 N5731RGoward Steven Lee · Oakley, MIBuilt 1965 · S/N 17253400 N5733RWarren Jeffrey · Omaha, NEBuilt 1965 · S/N 17253402 N5734RZ&H Aviation · Portage, MIBuilt 1965 · S/N 17253403 N5735RDavis Richard B · Reno, NVFirst renewal noticeBuilt 1965 · S/N 17253404 N5736GGagana Aviation LLC · Leander, TXBuilt 1969 · S/N 15071236 N5737RRegistration Pending · Chatham, NYRegistration pendingBuilt 1965 · S/N 17253406 N5738RKury Ernest A · Centerville, IABuilt 1965 · S/N 17253407 N5740GAdventist World Aviation · Wilson, NCBuilt 1969 · S/N 15071240 N5741RJungman Jensen David A · Adel, IAS/N 17253410 N5743JMidwest Aerial Photography · Galloway, OHBuilt 1970 · S/N P20600643 N5744RBrown Dallin N · Scipio, UTS/N 17253413 N5745GPettis Gary D · Lula, GABuilt 1969 · S/N 15071245 N5746RKrawietz William L · Bulverde, TXBuilt 1965 · S/N 17253415 N5747RLehmer Jereme D · Oxford, NYBuilt 1965 · S/N 17253416 N5748GKozar Theodore · Connellsville, PABuilt 1969 · S/N 15071248 N5748RStanley David W · Burleson, TXBuilt 1965 · S/N 17253417 N5749GPorter John W · Center, TXBuilt 1969 · S/N 15071249 N5749RMerrill Robert · Plymouth, MABuilt 1965 · S/N 17253418 N5750GHolt Wayne A · Waterford, MEBuilt 1969 · S/N 15071250 N5750RPeters Tricia S · Columbia City, INBuilt 1965 · S/N 17253419 N5751JB & H Drilg · Winnsboro, LABuilt 1971 · S/N 21059451 N5751RKummer Brian · Port Orange, FLBuilt 1965 · S/N 17253420 N5755REshbaugh Melvin L · Topeka, KSBuilt 1965 · S/N 17253424 N5756RCm3 LLC · North Las Vegas, NVS/N 17253425

Back to AD 72-03-03 R3