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.

N5896RRegistration Pending · Florence, MSRegistration pendingBuilt 1965 · S/N 17253565 N5898GIsaza Alvaro · Westminster, MDBuilt 1969 · S/N 15071398 N5899RParrish Aviation Flight Academy LLC · Dallas, TXS/N 17253568 N58BWarnick Ronald S · Cascade, MTBuilt 1968 · S/N 15068409 N5900JAir America LLC · Sioux Falls, SDS/N A1500200 N5900RAidan Hammond · Ione, CABuilt 1965 · S/N 17253569 N5902FPeters Kenneth R · Plainfield, ILBuilt 1967 · S/N 21058902 N5902RWojcik Dorene L · Cortland, OHS/N 17253571 N5903GRybarczyk Mathias M · Rice Lake, WIS/N 15071403 N5904FRegistered aircraftBuilt 1967 · S/N 21058904 N5905RSmart Harold J · Locust Grove, GABuilt 1965 · S/N 17253574 N5906GBennett Cass · Oxnard, CABuilt 1969 · S/N 15071406 N5906JErkie Norman R · Denison, TXS/N A1500206 N5906ROlson Bradley P · Pendleton, ORBuilt 1965 · S/N 17253575 N5907FIsland City Seaplanes Inc · Cordova, AKBuilt 1967 · S/N 21058907 N5907RBrown Kriss · Naperville, ILBuilt 1965 · S/N 17253576 N5908FCharger Aviation LLC · Chariton, IABuilt 1967 · S/N 21058908 N5908GRohrbough Nathan F · Weston, WVBuilt 1969 · S/N 15071408 N5909FHendrix Benton · Eckley, COBuilt 1967 · S/N 21058909 N5909RWagner Christopher J · Tulsa, OKBuilt 1965 · S/N 17253578 N5913GFerguson Joe C · Shreveport, LABuilt 1969 · S/N 15071413 N5913RWilliams Alonzo · Bentonville, ARBuilt 1965 · S/N 17253582 N5914RWaldrop Charles Trustee · Oklahoma City, OKBuilt 1965 · S/N 17253583 N5915FJeffries Phillip L · Belington, WVBuilt 1967 · S/N 21058915 N5916FTlc Flying Inc · Colfax, WABuilt 1967 · S/N 21058916 N5917RParcell Evelyn Cassandra · Norfolk, VAS/N 17253586 N5918JStansfield Carl B · Springdale, UTS/N A1500218 N5919JFiles Richard W · Yuma, AZBuilt 1970 · S/N A1500219 N5920RAmerican Eagle Aviation LLC · Flushing, MIBuilt 1965 · S/N 17253589 N5924GParsons Roderick L · Ripley, WVBuilt 1969 · S/N 15071424 N5926GMirandan5926g LLC · Napanoch, NYBuilt 1969 · S/N 15071426 N5927RRodrigues Robert R · Cordova, AKS/N 17253596 N5928FKerr Daniel · Bakersfield, CABuilt 1967 · S/N 21058928 N5928JParsons Royson A · Atascadero, CABuilt 1971 · S/N A1500228 N592HPAeroquest LLC · Olive Branch, MSBuilt 1973 · S/N 15075451 N5930FCable Strong Aircraft Holdings LLC · Tyler, TXS/N 21058930 N5930RDownwind Corp · Brush Prairie, WAS/N 17253599 N5931GOconnor Mary B · Anchorage, AKBuilt 1969 · S/N 15071431 N5932GBergen Henry E · Fond Du Lac, WIS/N 15071432 N5934GDevils Lake Aero Repair Inc · Devils Lake, NDS/N 15071434 N5934RHoyt Jacob T · Oneida, NYS/N 17253603 N5935GDeaero LLC · Darwin, MNBuilt 1968 · S/N 15071435 N5935RStofer William B · Warsaw, INBuilt 1965 · S/N 17253604 N5937FDodson International Parts Inc · Rantoul, KSBuilt 1967 · S/N 21058937 N5937GD'Arge Ranyon Wc · Wilson, WYBuilt 1969 · S/N 15071437 N5937RDavies Shane E · Kent, WAS/N 17253606 N5939GMasek Ron J · Valley City, OHBuilt 1969 · S/N 15071439 N5939RHester James T · Fayetteville, GAS/N 17253608 N5940RBakrevski Lupcho · Valparaiso, INS/N 17253609 N5941RChristian Stuart J · Erskine, MNS/N 17253610

Back to AD 72-03-03 R3