Skip to content

Registered aircraft · 26,232

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N6770EKoyle Bruce Ronald · Rancho Cucamonga, CABuilt 1959 · S/N 56270 N6770FFaith Tabernacle Ministries Inc · Junction City, KSBuilt 1966 · S/N 15063370 N6771EKlingman Matthew W · Chappell, NEBuilt 1959 · S/N 56271 N6771HHaynes Thomas E · Avon Park, FLS/N 19986 N6772FIrlbeck Cyler M · Eden Prairie, MNBuilt 1966 · S/N 15063372 N6774ERegistration Pending · Crystal, MNRegistration pending, pending cancellationBuilt 1959 · S/N 56274 N6774SBennington Aaron G · Delaware, OHBuilt 1967 · S/N 15067574 N6775AField Eaton Fredrick F · Tigard, ORBuilt 1956 · S/N 28875 N6775ECk Leasing Services LLC · Wilmington, DEBuilt 1959 · S/N 56275 N6775GBannock Anthony O · Anchorage, AKS/N 15072275 N6776GWalters John S · Durham, CABuilt 1970 · S/N 15072276 N6777AScheithauer Christopher P · Cement City, MIBuilt 1956 · S/N 28877 N6777EQunell Jamie R · Corcoran, MNBuilt 1959 · S/N 56277 N6777SEhrhardt Paul R · Junction City, ORBuilt 1967 · S/N 15067577 N6778AQuadrani Anthony · Kingsford, MIBuilt 1956 · S/N 28878 N6779FBeulah Ranch LLC · Cheyenne, WYBuilt 1966 · S/N 15063379 N6779HCarraher Mark T · Spalding, NEBuilt 1946 · S/N 19993 N6782EPeters John K · Bonner Springs, KSBuilt 1959 · S/N 56282 N6782GWilson Zachary R · Richland Center, WIFirst renewal noticeBuilt 1970 · S/N 15072282 N6784AAtlantic Rotors LLC · Saint Inigoes, MDBuilt 1956 · S/N 28884 N6784ESwedberg Randy M · Kingman, KSS/N 56284 N6784HButcher Darren E · Lakeland, TNBuilt 1946 · S/N 19997 N6785SSchmidt Gary C · Sunrise Beach, MOBuilt 1967 · S/N 15067585 N6786ARutledge Brett B · Yuma, COS/N 28886 N6786FBeitz Norman Roy · Quitman, TXS/N 15063386 N6786HHogg James R · New Albany, OHBuilt 1946 · S/N 19999 N6789AChris Fuher Flight Instruction LLC DBA · Townsend, MTS/N 28889 N6789EHeinen Avionics LLC · Adrian, MIBuilt 1959 · S/N 56289 N6789WAspiring Aviators Aero Club Inc · Winter Haven, FLS/N 47-1222 N678DWAnderson Timothy · Pilot Rock, ORBuilt 1957 · S/N 7FC-95 N678KPalm Steven · Madera, CABuilt 1956 · S/N 29454 N678RMLaw Roger Jay · Franklin, INBuilt 1961 · S/N 17248390 N6790ALaurel 406 Aero · Billings, MTS/N 28890 N6790GMartin Christopher G · Monessen, PABuilt 1970 · S/N 15072290 N6790SHildreth Jon R · Spencer, WVBuilt 1967 · S/N 15067590 N6792FPatton Aviation LLC · Billings, MTBuilt 1966 · S/N 15063392 N6792SJohnston Robert G · Rose Hill, KSBuilt 1967 · S/N 15067592 N6793AJones Jeffrey D Trustee · Elida, OHBuilt 1956 · S/N 28893 N6793EBig South Fork Aerospace LLC · Pine Knot, KYBuilt 1959 · S/N 56293 N6793FOgden John T · Meridian, IDBuilt 1966 · S/N 15063393 N6793GExecutive Flight Institute LLC · Murrieta, CABuilt 1970 · S/N 15072293 N6794GLawson Kurt J · Melbourne, FLBuilt 1970 · S/N 15072294 N6795AKelley Aviation Services Inc · Halifax, PAFirst renewal noticeBuilt 1956 · S/N 28895 N6796AAjer Richard L · Herriman, UTBuilt 1956 · S/N 28896 N6796GLyon Scott T · Wellsville, KSBuilt 1970 · S/N 15072296 N6796SRegistration Pending · Lawrence, KSRegistration pendingS/N 15067596 N6797FGriswold M Dallas · Cordele, GABuilt 1966 · S/N 15063397 N67983Jamison Connor A · Salinas, CABuilt 1947 · S/N 12808 N6798GCowan Ronnie C · Glasgow, KYS/N 15072298 N6799GWetzler Brian · Bainbridge Island, WABuilt 1970 · S/N 15072299

Back to AD 94-05-05 R1