Skip to content

Registered aircraft · 17,028

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.

N84465Double Bridges Aviation LLC · Enterprise, ALBuilt 1969 · S/N 17258482 N84468Whiting Joseph · Roy, UTBuilt 1969 · S/N 17258485 N8446JBent James L Jr DBA · Palatine Bridge, NYS/N 15066346 N8446SInfanger Jim Bob · Salmon, IDFirst renewal noticeBuilt 1965 · S/N 18256546 N8446ZRegistration Pending · Liberty Lake, WARegistration pendingBuilt 1963 · S/N 205-0446 N84473Lawrence Blake C · Monument, ORBuilt 1969 · S/N 17258487 N8447SSteinheiser Terry N · Renfrew, PABuilt 1965 · S/N 18256547 N8447ZKorenko Kirk A · Granite Bay, CABuilt 1963 · S/N 205-0447 N84489Rinkenback Keven H · Kailua-Kona, HIBuilt 1970 · S/N 17258491 N8448GMidwest Aviation Services LLC · Kendallville, INBuilt 1965 · S/N 15062548 N8448MMohamed Jaleel · Dallas, TXBuilt 1969 · S/N A1500148 N8448UGillis Christopher Paul · Fredericksburg, VABuilt 1964 · S/N 17252348 N8449JSchaff James F · Gakona, AKBuilt 1967 · S/N 15066349 N8449MCopper River Airmotive LLC · Copper Center, AKBuilt 1969 · S/N A1500149 N8449SHollensbe Brant W · West Des Moines, IABuilt 1965 · S/N 18256549 N8450LElghammer Garrott W · Niles, MIBuilt 1968 · S/N 17256650 N8450MChoquette Marc J · Juneau, AKBuilt 1969 · S/N A1500150 N8450UJust-Plane-Fun LLC · Searcy, ARBuilt 1964 · S/N 17252350 N84510Levine Peter D · Bisbee, AZBuilt 1969 · S/N 17258503 N84511Lands Brian Lee · Blacklick, OHBuilt 1969 · S/N 17258504 N84515Abbott Sean N · South Paris, MES/N 17258507 N84518Ropp Dennis A · Albany, ORS/N 17258509 N8451MDelalat Shariar · San Diego, CABuilt 1970 · S/N A1500151 N8451ZHagelstein Ele C · Sanderson, TXBuilt 1963 · S/N 2050451 N84529Eckert Philip · Paso Robles, CABuilt 1969 · S/N 17258512 N8452LParr Terri M · Catlin, ILBuilt 1968 · S/N 17256652 N8452MHigh Flight LLC · Mount Pleasant, SCS/N A1500152 N8452UGibson Gregory I · Ivel, KYS/N 17252352 N84531Northumberland Flying Club Inc · Gansevoort, NYBuilt 1969 · S/N 17258513 N8453GBelue Gaythan D · Rogersville, ALBuilt 1965 · S/N 15062553 N8453SHarvey Paul E · Richmond, MES/N 18256553 N8453USappah Guy · Lusby, MDBuilt 1964 · S/N 17252353 N84541Stack Kenneth J · Carnegie, PABuilt 1969 · S/N 17258516 N84544Cruz Pedro · Tampa, FLBuilt 1969 · S/N 17258517 N8454ZParker Larry C · Roswell, NMBuilt 1963 · S/N 205-0454 N8455JBentz Jack E · Huntington, WVBuilt 1967 · S/N 15066355 N8455LYoumans Ronald E · Baxley, GABuilt 1968 · S/N 17256655 N8455UOverton James D · Midland, TXBuilt 1964 · S/N 17252355 N84566Dulin Morgan L · Midland, TXBuilt 1969 · S/N 17258524 N84567Hixson Steven Dee · Longview, WABuilt 1969 · S/N 17258525 N84569Nielsen David R · Sarona, WIBuilt 1970 · S/N 17258526 N8456GAerial Perspective Inc · Fullerton, CABuilt 1965 · S/N 15062556 N8456JHam Russell W · Dike, TXBuilt 1967 · S/N 15066356 N8456LCherryhill Aviation Inc · Freetown, INBuilt 1968 · S/N 17256656 N8456SPalmer Jay H · Baraboo, WIBuilt 1965 · S/N 18256556 N8456ZOpus Aviation LLC · South Hero, VTBuilt 1963 · S/N 205-0456 N84573Lee Mark J · La Habra Heights, CABuilt 1969 · S/N 17258528 N84575Pee Dee Avionics Inc · Chesterfield, SCBuilt 1969 · S/N 17258530 N84578San Juan Skyhawks Inc · Friday Harbor, WABuilt 1969 · S/N 17258532 N84579Parchesky Joseph Trustee · Pipe Creek, TXBuilt 1969 · S/N 17258533

Back to AD 72-03-03 R3