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.

N18586Flyit LLC · Camas, WABuilt 1972 · S/N 15073964 N18587Payne Frederick B · Fayetteville, GABuilt 1972 · S/N 15073965 N1858QScott Air LLC · Cave Creek, AZBuilt 1972 · S/N 177RG0258 N1858XSalem Aero Club Inc · Bridgeton, NJBuilt 1964 · S/N 18255958 N1858ZPairofminutes LLC · Marshville, NCS/N 205-0058 N18590Williams Michael · Williston, FLBuilt 1972 · S/N 15073968 N18594Robinson Ronald W · Saint Joseph, MIBuilt 1972 · S/N 15073970 N18596Baxter Wiley · Glennville, GABuilt 1972 · S/N 15073972 N18597Kiser Joshua Alan · Dry Ridge, KYS/N 15073973 N18598Gudgel Aviation · Lemoore, CABuilt 1972 · S/N 15073974 N1859FBaker Robert J · Ogema, MNBuilt 1966 · S/N 21058759 N185WTPenley Robert G · Corinth, TXBuilt 1972 · S/N 15073919 N18602Poston James M · Hixson, TNBuilt 1976 · S/N 17702544 N18612Missoula Fliers LLC · Milltown, MTBuilt 1972 · S/N 15073987 N18618Hammons Bryan S · Stephenville, TXBuilt 1972 · S/N 15073991 N1861XCabreja Sanchez Elmer · Carolina, PRBuilt 1964 · S/N 18255961 N1861ZPadden Geary L · Duluth, MNBuilt 1962 · S/N 205-0061 N18623Fleischmann Fred · Racine, WIBuilt 1972 · S/N 15073994 N18627Oberhansly Lucas C · Roy, WABuilt 1972 · S/N 15073998 N18628Paul William A · Windfall, INBuilt 1972 · S/N 15073999 N1862QB & P Transportation LLC · Mount Blanchard, OHBuilt 1972 · S/N 177RG0262 N1862XCose Gary D · Livermore, CABuilt 1964 · S/N 18255962 N18630Gaddy Tyler Quintin · Advance, NCBuilt 1972 · S/N 15074000 N18634Bagge William J · East Longmeadow, MABuilt 1972 · S/N 15074004 N18637Vincent Addison J · Waynesburg, OHBuilt 1972 · S/N 15074006 N1863FAndersen Dana K · Scappoose, ORS/N 21058763 N1863QCollins David A · Portland, ORBuilt 1972 · S/N 177RG0263 N18640Smith David W · Elgin, SCBuilt 1972 · S/N 15074008 N18643Registered aircraftN-number assigned, not yet registeredS/N 17702545 N18645Sorenson Mark A · Senoia, GAS/N 15074011 N18649Dixon Robert D · Derry, PABuilt 1972 · S/N 15074015 N1864FSwensen Nathan E · Winnemucca, NVS/N 21058764 N18656Larsen Steve · Colton, ORBuilt 1972 · S/N 15074019 N1865XAria & Arjun LLC · Cumming, GABuilt 1964 · S/N 18255965 N1865ZBpf Equipment LLC · Burnet, TXBuilt 1962 · S/N 205-0065 N18663Van Dyke John · Hopkins, MIBuilt 1973 · S/N 15074025 N1866QPez Air LLC · Cleveland Heights, OHBuilt 1972 · S/N 177RG0266 N18674Vandervegt Nathan J · Juneau, AKBuilt 1972 · S/N 15074034 N18678Laviolette Stephen O · Dallas, TXBuilt 1972 · S/N 15074037 N1867FIcarus Aviators LLC · Canon City, COBuilt 1966 · S/N 21058767 N1867XWaypoint208 LLC · Chubbuck, IDBuilt 1964 · S/N 18255967 N18686Duvoisin Tom Jr · Powell, TNBuilt 1972 · S/N 15074041 N1868ZZulu Forty One LLC · Anchorage, AKBuilt 1962 · S/N 205-0068 N18694Hughes Randall L · Post Falls, IDBuilt 1976 · S/N 17702547 N18697Cannon Corey D · Elk Grove, CABuilt 1972 · S/N 15074049 N1869FRegistration Pending · Dublin, OHRegistration pendingBuilt 1966 · S/N 21058769 N1869XFlying Yankees Inc · Nashua, NHBuilt 1964 · S/N 18255969 N1869ZPinnell Bradley T · Lake Havasu City, AZBuilt 1962 · S/N 205-0069 N186RDWayson Air LLC · Mount Auburn, IABuilt 1966 · S/N 21058761 N186RZRex Zollinger Aviation LLC · Woods Cross, UTBuilt 1969 · S/N 18259557

Back to AD 72-03-03 R3