Skip to content

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.

N933PAerowood Aviation LLC · Monroe, NCBuilt 1964 · S/N 17252361 N9342RCampbell Gene H · Baytown, TXBuilt 1978 · S/N 17702752 N9343XYoung Charles T · Los Banos, CABuilt 1962 · S/N 18253743 N9345XBordner Christopher P · Santa Cruz, CABuilt 1961 · S/N 18253745 N9348XWhittemore Kenneth P Jr · Fredericksburg, VABuilt 1962 · S/N 18253748 N9349XDicarlo Jason M · Covington, LABuilt 1962 · S/N 18253749 N9352XLinhart Charles W · Dayton, WYBuilt 1962 · S/N 18253752 N9356XGibson Kenneth W · Washougal, WAS/N 18253756 N935CBCalifornia Baptist University · Riverside, CABuilt 1971 · S/N 15073101 N9360XReist Glenn A · Moulton, ALBuilt 1962 · S/N 18253760 N9364XHatfield Steven P Trustee · Clearwater, KSBuilt 1962 · S/N 18253764 N9365MFiglia Emanuele · Lewes, DEBuilt 1972 · S/N 15073211 N9365XHallows Hc Holdings LLC · Salina, UTBuilt 1962 · S/N 18253765 N9367XLivingston Robin L · Vail, AZBuilt 1962 · S/N 18253767 N9368XS & D Aviation LLC · Pamplico, SCBuilt 1962 · S/N 18253768 N9369XPletcher Marvin D · Yuma, COBuilt 1962 · S/N 18253769 N9371XAdventure Aircraft And Equipment LLC · Chelan, WABuilt 1962 · S/N 18253771 N9372XSleeping Giant Flying Club Inc · Helena, MTBuilt 1962 · S/N 18253772 N9375XRubber Chicken Airlines LLC · Kalispell, MTS/N 18253775 N9376MBeans James B IV · Camas Valley, ORBuilt 1972 · S/N 17260576 N9379XFoster Hartford L · Whitefield, MEBuilt 1962 · S/N 18253779 N9380XJacobi Gregory A · Alex, OKBuilt 1962 · S/N 18253780 N9381XLazy Eight Flying Club LLC · New Richmond, WIBuilt 1962 · S/N 18253781 N9385XPipkorn Alan J · Phillips, WIBuilt 1962 · S/N 18253785 N9387XKillam Rodney A · Carlinville, ILBuilt 1962 · S/N 18253787 N9389XBeckelic Michael E · Acworth, GABuilt 1962 · S/N 18253789 N9391XGravenstede Nelson F · Newton, NJBuilt 1962 · S/N 18253791 N9394XBlue Sky Flyers Inc · Punta Gorda, FLBuilt 1962 · S/N 18253794 N9398XRegistration Pending · Chillicothe, OHRegistration pendingBuilt 1962 · S/N 18253798 N9399XStorm Flying Service LLC · David City, NEBuilt 1962 · S/N 18253799 N93BZMoreno Joseph L · San Diego, CABuilt 1966 · S/N 18257189 N93PSVanderflute Scott L · Lakewood, WAS/N 17251979 N93TPBagley Corydon S · Holladay, UTBuilt 1965 · S/N 17252041 N94000Champion Aircraft LLC · Valdosta, GAS/N 17258297 N9400GMurphy James T · Nashville, TNBuilt 1970 · S/N U20601600 N9401GNoble Cody Trustee · Ardmore, OKBuilt 1970 · S/N U20601601 N940WSkyhawks Inc · Westminster, COBuilt 1965 · S/N 18256606 N9410MWomack David H · Rayville, LAS/N 21059310 N9412MFly-N-High LLC · Riverton, WYBuilt 1970 · S/N 21059312 N9420MSideline Services LLC · Pearland, TXBuilt 1970 · S/N 21059320 N9428GSecond Wind Aviation Corp · Friday Harbor, WABuilt 1970 · S/N U20601628 N942SAWalker John A · Kotzebue, AKS/N TU2060553 N942SMMackie Jonathan M · Manistique, MIBuilt 1969 · S/N T210-0416 N942XAClymer Jordan · Cape Canaveral, FLS/N 15070510 N9430MKruschwitz David A · Anchorage, AKBuilt 1974 · S/N 15075669 N9433MDels Inc · Mountain Home, ARBuilt 1970 · S/N 21059333 N9442Winger Aviation LLC · Palatine, ILBuilt 1973 · S/N 177RG0324 N9446GStringfellow Regan M · Boerne, TXS/N U20601646 N944RRancifer Rodney M · Lithonia, GABuilt 1970 · S/N 17258933 N9452GStokes Letta J · Chugiak, AKBuilt 1971 · S/N U20601652

Back to AD 72-03-03 R3