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.

N1827XFlatland Farms LLC · Hooker, OKBuilt 1964 · S/N 18255927 N1828FDrew Kevin · Fredonia, PABuilt 1965 · S/N 21058728 N1828ZHorrocks Charles M · Blackfoot, IDBuilt 1962 · S/N 205-0028 N1829QMaracle Wayne M Jr · Papillion, NEBuilt 1971 · S/N 177RG0229 N1829XWise Dennis E · Battle Ground, WAS/N 18255929 N1829YWing And A Prayer Aviation LLC · Cabot, ARS/N 18257815 N182AEVold Steven A Trustee · Billings, MTS/N 18257710 N182ALItm Aircraft LLC · Charleston, SCBuilt 1970 · S/N 18260549 N182ARRyan Jeffrey W · Westminster, COBuilt 1964 · S/N 18255472 N182BAE&S Aviation LLC · Brandon, MSBuilt 1970 · S/N 18260287 N182BRRosenkoetter Brandon Lee · Boise, IDS/N 18259827 N182CJJackson George K · Jonesboro, ARBuilt 1961 · S/N 18253671 N182CLAdr Aircraft Service Inc · Burbank, CABuilt 1966 · S/N 18257001 N182DBBender Flight LLC · Camano Island, WABuilt 1964 · S/N 18255607 N182DGDahle Construction LLC · Salmon, IDBuilt 1969 · S/N 18260003 N182DHWills James M · Farmville, VABuilt 1962 · S/N 18253909 N182DVHusbands David C · Bosque, NMBuilt 1968 · S/N 18259430 N182DYMueller Matthew C · Stamford, TXBuilt 1968 · S/N 18258966 N182EQAthen Daniel R · Rock Port, MOBuilt 1969 · S/N 18259646 N182FFHackney Jessie · Ripley, WVBuilt 1967 · S/N 18258721 N182FTSteves Christmas Trees Inc · Diamond Springs, CABuilt 1965 · S/N 18256715 N182GEGmr Leasing LLC · Lincoln, DEBuilt 1962 · S/N 18254299 N182GGDel Giorgio Martin A · Flagstaff, AZBuilt 1969 · S/N 18260193 N182GSSmith Gregory E · White Lake, MIBuilt 1967 · S/N 18258101 N182GWLeflore Investors Inc · Greenwood, MSBuilt 1968 · S/N 18259166 N182HAvquad Inc · Fort Collins, COBuilt 1965 · S/N 18255990 N182JBSkylane182jb LLC · Martinsville, INBuilt 1966 · S/N 18257823 N182JENunatak Air LLC · Fairbanks, AKBuilt 1962 · S/N 18254111 N182JGLogan Barry L · Shell Knob, MOBuilt 1970 · S/N 18260315 N182JJJ & J Aero · Chuckey, TNBuilt 1962 · S/N 18254379 N182JWAgri-Air Service Inc · Middletown, DEBuilt 1967 · S/N 18258366 N182KFPlante Matthew · Blackstone, MABuilt 1962 · S/N 18254358 N182KLLabonte Kenneth H · Lakeville, MABuilt 1968 · S/N 18259500 N182LDLutian Mark J · Raymond, MEBuilt 1965 · S/N 18256362 N182LHHudspeth Lance A · Redmond, ORBuilt 1965 · S/N 18256305 N182LJSky Ranch Development LLC · Las Vegas, NVBuilt 1967 · S/N 18258167 N182LRSouthwest American Woodworks LLC · Phoenix, AZBuilt 1965 · S/N 18256847 N182MService Oriented Aviation Readiness (Soar) · Bolivar, MOS/N 18255118 N182MLDsr Cherokee 180 LLC · Dallas, TXBuilt 1966 · S/N 18256730 N182MPKelly Randolph H · Shelbyville, TNS/N 18259137 N182MYMiyazaki Yasutaka · Phoenix, AZBuilt 1966 · S/N 18257857 N182NHighly Favored One LLC · Las Vegas, NVBuilt 1971 · S/N 18260683 N182NHWingingitin LLC · Georgetown, INBuilt 1969 · S/N 18260148 N182NSJefferson Aircraft LLC · Metairie, LABuilt 1968 · S/N 18258888 N182PTMohawk Associates Inc · Wilmington, DES/N 18259948 N182RFBuman Donald A · Windsor, COBuilt 1966 · S/N 18257620 N182RMTruex T E · Georgetown, INBuilt 1966 · S/N 18257389 N182SRBaldwin Steve · Kearney, MOBuilt 1965 · S/N 18256571 N182STRose David Hugh · Rosamond, CABuilt 1967 · S/N 18258051 N182SXRiley Spraying Service Inc · Norton, KSBuilt 1968 · S/N 18259477

Back to AD 72-03-03 R3