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.

N8372LRed Sky Aviation LLC · Livermore, CABuilt 1968 · S/N 17256572 N8373GColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1965 · S/N 15062473 N8373LFaulkner Jeannine P · Bethel, AKFirst renewal noticeBuilt 1968 · S/N 17256573 N8373MBond Hiram E · Pls Vrds Est, CABuilt 1969 · S/N A1500073 N8373SBart Bruno Paul · Monterey, CABuilt 1965 · S/N 18256473 N8373UKramer Mark S · Branchburg, NJBuilt 1964 · S/N 17252273 N8374LGeneral Aviation LLC · Henderson, NVBuilt 1968 · S/N 17256574 N8375JAtlanta Aircraft Consultants LLC · Rex, GABuilt 1967 · S/N 15066275 N8375SAero Glide Corporation · Sedona, AZBuilt 1965 · S/N 18256475 N8376MPhillips Lester L · Pahrump, NVS/N A1500076 N8377MBoyd Edward Lee · Apison, TNBuilt 1969 · S/N A1500077 N8378LLett Brian R · Eden Prairie, MNBuilt 1968 · S/N 17256578 N8378MKuklo Robert M · Livermore, CABuilt 1969 · S/N A1500078 N8378SGulley Ronald L · Boise, IDBuilt 1965 · S/N 18256478 N8378ZKling Jeffrey V · Friendswood, TXBuilt 1963 · S/N 205-0378 N8379JLin Air LLC · Oviedo, FLBuilt 1967 · S/N 15066279 N8379LSan Fernando Aviation LLC · Van Nuys, CAS/N 17256579 N8379SAir Dakota Flite Inc · Hettinger, NDBuilt 1965 · S/N 18256479 N8380UTrp Enterprises Inc · Mocksville, NCBuilt 1965 · S/N 17252280 N8381LShielded Holdings LLC - Series Av 12 · Katy, TXBuilt 1968 · S/N 17256581 N8381UFuryious Aviation LLC · Bossier City, LABuilt 1964 · S/N 17252281 N8381ZVoran Carlon R · Port Alsworth, AKBuilt 1963 · S/N 205-0381 N8382GArneson Kenneth W · Beaverton, ORS/N 15062482 N8382JHouseknecht Thomas · State College, PABuilt 1967 · S/N 15066282 N8382LMedina Solla Edwin O · Trujillo Alto, PRBuilt 1968 · S/N 17256582 N8382SFitzwater Richard B · Athol, IDBuilt 1965 · S/N 18256482 N8383MKessler Aviation LLC · Lansing, WVBuilt 1969 · S/N A1500083 N8383UBuzby Justin T · Wasilla, AKBuilt 1964 · S/N 17252283 N8384GWoodall Steve W · Penngrove, CABuilt 1965 · S/N 15062484 N8384JKondol Andrlej J · Maspeth, NYBuilt 1967 · S/N 15066284 N8384M1st Clev-Mar LLC · Gainesville, TXBuilt 1969 · S/N A1500084 N8385JJones Stanley E · Vallejo, CABuilt 1967 · S/N 15066285 N8385LKrebs Lisa Christine · Homer, AKBuilt 1968 · S/N 17256585 N8385ZHoneysett Robert E Jr · Anchorage, AKS/N 205-0385 N8386GIndy Hot Air LLC · Westfield, INBuilt 1965 · S/N 15062486 N8386JMyers Raymond R · Deer Park, WABuilt 1967 · S/N 15066286 N8386LAdams Haidyn · Pentwater, MIS/N 17256586 N8386SDavis Lawrence R · Kent, OHS/N 18256486 N8387GAir Land And Sea Adventures LLC · West Palm Beach, FLBuilt 1965 · S/N 15062487 N8387LSerra Christopher R · Snellville, GABuilt 1968 · S/N 17256587 N8387URegistered aircraftBuilt 1964 · S/N 17252287 N8388JCunningham Kevin M · Alexandria, MNS/N 15066288 N8388SRose Mary R · Portland, ORBuilt 1965 · S/N 18256488 N8389LJkg LLC · Murfreesboro, TNBuilt 1968 · S/N 17256589 N8389MTechnical Education Services Inc T/A · Virginia Beach, VABuilt 1969 · S/N A1500089 N8389SGriffith Kevin D · Lakeview, MIBuilt 1965 · S/N 18256489 N838HPKeathley Jeremie L · Rolla, MOBuilt 1966 · S/N 15062786 N838MPWhitney Stephen · Fort Myers, FLS/N 17258274 N8390LBliss Marketing Communications Inc · Phoenix, AZBuilt 1968 · S/N 17256590 N8390ZJp Aero Holdings Inc · Carson City, NVBuilt 1963 · S/N 205-0390

Back to AD 72-03-03 R3