Skip to content

Registered aircraft · 1,642

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:74-18-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-13') 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:74-18-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-13')
  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:74-18-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-13')
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.

N31396Pucciarelli Albert J · Ridgewood, NJBuilt 1978 · S/N 32-7840129 N31407Montei Nicholas P · Caro, MIS/N 32-7840130 N3147DOrr Calvin L · Higginsville, MOBuilt 1968 · S/N 32-40412 N31536Island Air Taxi LLC · Put In Bay, OHBuilt 1978 · S/N 32-7840132 N31569Snyder Bradley R · Johnstown, PABuilt 1978 · S/N 32-7840133 N31571Cg Air LLC · Mason City, IABuilt 1978 · S/N 32-7840134 N31589Redemption Leasing LLC · Kodiak, AKBuilt 1978 · S/N 32-7840135 N31657Wynne Kenneth H · Branford, CTBuilt 1978 · S/N 32-7840139 N31699Donahue Investments LLC · Port Orange, FLBuilt 1948 · S/N 32-7840142 N316MABlue Side Up Inc · Islamorada, FLBuilt 1976 · S/N 32-7640112 N316VUpstate Sc Flyers LLC · West Union, SCBuilt 1979 · S/N 32-7940027 N31700Ratcliff Bruce A · Plain City, OHBuilt 1978 · S/N 32-7840143 N31736Lees Sea Air · Kiana, AKBuilt 1978 · S/N 32-7840145 N31737Scs Construction LLC · Cape May Ch, NJBuilt 1978 · S/N 32-7840146 N31841Rotormate LLC · Royse City, TXBuilt 1978 · S/N 32-7840149 N31871Dodson Randall L · New Hope, MNBuilt 1978 · S/N 32-7840150 N31885It Is Well · Kennett, MOBuilt 1978 · S/N 32-7840152 N31916Registered aircraftS/N 32-7840155 N31JWMiller Scott A · Granbury, TXBuilt 1973 · S/N 32-7300047 N31NDSchloesser Raymond E · Poland, INS/N 32-654 N31PWClark David L · Washoe Valley, NVBuilt 1968 · S/N 32-40510 N31REManley Brian C · Glen Allen, VABuilt 1966 · S/N 32-530 N31RFLegend48 LLC · Newton, NCS/N 32-7700023 N3200WBrickley Brian J · Manchester, MIBuilt 1964 · S/N 32-04 N32037Conyers Jeffrey P · Sevierville, TNBuilt 1974 · S/N 32-7540009 N3207WZero Seven Whiskey LLC · Norco, CABuilt 1965 · S/N 32-7 N32117Stough Stephen A · Reno, NVBuilt 1974 · S/N 32-7540016 N32139Bidzy Ta Hot Aana Corporation · Dillingham, AKFirst renewal noticeBuilt 1974 · S/N 32-7540017 N3213WElmore Terry · Berry, ALS/N 32-13 N3214WHolcombe Vell C · Hershey, PABuilt 1965 · S/N 32-15 N3215WDiederich Chad · Chesapeake, VABuilt 1965 · S/N 32-16 N3217WNorth Anthony B · Bloomfield, CTBuilt 1965 · S/N 32-19 N32187Free Lutheran Association Of Pilot Supporters Inc · Plymouth, MNBuilt 1974 · S/N 32-7540021 N32197Brunzlick Larry R · Chuckey, TNBuilt 1974 · S/N 32-7540022 N321DPDelta Papa LLC · Henderson, NVBuilt 1979 · S/N 32-7940032 N321HPNfas LLC · League City, TXBuilt 1974 · S/N 32-7440099 N321SPWest Electrical Contractors Inc · Newberry, SCBuilt 1974 · S/N 32-7440119 N3220WBarnes Matthew Thomas · Valdosta, GABuilt 1965 · S/N 32-25 N3221WRay Troy D · Roanoke, VAFirst renewal noticeBuilt 1965 · S/N 32-27 N3223WWaynen Michael C · Runaway Bay, TXS/N 32-30 N3224WMedic Choppers LLC · Springdale, ARS/N 32-31 N3225WCherokee Aero Group Inc · Lakeland, FLBuilt 1965 · S/N 32-33 N3226WAlbert James R · Corpus Christi, TXBuilt 1965 · S/N 32-34 N322CCHall Robert · North Canton, OHS/N 32-7940117 N32303Eagle Air Solutions LLC · Johnson City, TNBuilt 1974 · S/N 32-7540029 N3230WHagan Jackson · Wetumpka, ALBuilt 1965 · S/N 32-40 N3231BEast Martin D · Nicholasville, KYBuilt 1974 · S/N 32-7540030 N3231WDouble F Enterprise LLC · Paullina, IABuilt 1965 · S/N 32-42 N3233WPickens Nathan A · Caldwell, IDS/N 32-45 N32348Ramsey Time LLC · Winter Garden, FLBuilt 1974 · S/N 32-7540032

Back to AD 74-18-13