Skip to content

Registered aircraft · 17,023

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.

N124RCEc Aviation Inc · Stockbridge, GABuilt 1970 · S/N 17258537 N1250QSantiago Luis R · Waller, TXBuilt 1971 · S/N 15072550 N1251Miltz Karl W · Black River, MIS/N 17254758 N1254QWeber Joel A · Goddard, KSBuilt 1971 · S/N 15072554 N1255CHaslett Lisa L · Vinita, OKBuilt 1977 · S/N 17702691 N1255QDrucker Jonathan · Spring Hill, FLBuilt 1971 · S/N 15072555 N1256CC177 Heavy LLC · Colfax, NCS/N 17702692 N1256QRose Kerry D · Liberal, MOBuilt 1971 · S/N 15072556 N1259QBuckles Ryan · Mont Belvieu, TXS/N 15072559 N125AWWaterwings Seaplanes LLC · Hoover, ALBuilt 1967 · S/N 15066417 N125JDLeppien John C · Alma, MIBuilt 1974 · S/N 17702130 N125TLPease Lynn A · Elizabeth, ILS/N 18255291 N1261QLeas Michael A · Bemidji, MNBuilt 1971 · S/N 15072561 N1262QSandford Graves M · Moberly, MOS/N 15072562 N1264QYeghikian Sarmen · Glendale, CABuilt 1971 · S/N 15072564 N1265QDumankskii Aviation LLC · Columbus, OHBuilt 1971 · S/N 15072565 N1267QWiltshire Henry C Jr · Plymouth, MABuilt 1971 · S/N 15072567 N1269CNovember 1269 Charlie LLC · East Montpelier, VTBuilt 1979 · S/N 17702693 N1269RThompson Steve E · Port Angeles, WABuilt 1968 · S/N 17700625 N126KWersinger Duncan · Rochester, NYBuilt 1968 · S/N 17257392 N126SMMathis Shannon Dwayne · Richmond, KYBuilt 1969 · S/N 15070492 N1270QCessna 1270q Partnership · Glenside, PABuilt 1971 · S/N 15072570 N12767Lipstreu William H · Hudson, OHBuilt 1975 · S/N 17702386 N127826350 LLC · Yorklyn, DES/N 17702387 N1279QCerrit LLC · Helena, MTBuilt 1971 · S/N 15072579 N127VCSmith Von T · Chelan, WABuilt 1967 · S/N 18258041 N1283QMacaruso Matthew H · Warwick, RIBuilt 1971 · S/N 15072583 N1284QHogan Resources Inc · Bedford Hills, NYBuilt 1971 · S/N 15072584 N1285QDavis Allen J · Weidman, MIBuilt 1971 · S/N 15072585 N12868Gregg William V · Greensburg, PABuilt 1975 · S/N 17702390 N1288QCahill Chad · Edmond, OKS/N 15072588 N1289QLong Jeffrey K Trustee · The Villages, FLBuilt 1971 · S/N 15072589 N128BWRodriquez Roy L DBA · Martin, TNBuilt 1969 · S/N 18260080 N128CGMontaez Torrez Raul · Guaynabo, PRBuilt 1968 · S/N 17256621 N128RVande Hei Joshua G · Kaukauna, WIBuilt 1968 · S/N 17256984 N128RRRegistered aircraftS/N 15070734 N1290KN1290k LLC · Dover, DEBuilt 1965 · S/N 18256650 N1291PPowers Elbie L · Roseboro, NCBuilt 1965 · S/N 18256573 N1292CTrout Island Transit LLC · Glen Ellyn, ILBuilt 1977 · S/N 17702696 N1293QCoxwell James L · Midlothian, TXBuilt 1971 · S/N 15072593 N1294CJel Imaging Services LLC · Rochester, NYBuilt 1977 · S/N 17702698 N1294QKimmons Anthony J · Bogue Chitto, MSBuilt 1971 · S/N 15072594 N1296CLogan Tom B Trustee · Coeur D Alene, IDBuilt 1977 · S/N 17702699 N1296QFey Brian F · Waycross, GABuilt 1971 · S/N 15072596 N12984Go Fly Az LLC · Gilbert, AZBuilt 1975 · S/N 17702394 N12CHKetchum Christensen Sky Chasers LLC · Midwest City, OKBuilt 1966 · S/N 18257291 N12HBAerotechniques LLC · South Kent, CTBuilt 1977 · S/N 177RG1124 N12JTHines Thomas J · Amsterdam, NYBuilt 1972 · S/N 15073955 N12MMHigh Exposure Inc · Wilmington, DEBuilt 1968 · S/N 15069873 N1300QA-Cent Aviation Inc · Jacksonville, FLBuilt 1971 · S/N 15072600

Back to AD 72-03-03 R3