Skip to content

Registered aircraft · 6,238

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

N22VXDo Good Things LLC · Port Orange, FLBuilt 1978 · S/N TJ-171 N22WSJ M Mcleod Farms LLC · Carthage, NCBuilt 1979 · S/N E-1506 N22ZV2 Blondes On Board LLC · Brenham, TXBuilt 1979 · S/N E-1570 N2302CDuck & Goose Aviation Inc · St Simons Island, GABuilt 1997 · S/N E-3102 N2303VFindlay Fly Boys LLC · Findlay, OHBuilt 1998 · S/N E-3168 N2307CStuffmann Eric S · Orinda, CABuilt 1997 · S/N E-3107 N2307JMidwest Kilo Delta LLC · Clara City, MNBuilt 1997 · S/N EA-607 N230DDStrobe 33 LLC · Houston, TXBuilt 1978 · S/N CE-835 N230EASea Hawk Airways LLC · Largo, FLS/N E-3530 N2311VB & L Henry LLC · Chipley, FLBuilt 1997 · S/N E-3111 N2317SSokoloff James T · Cambridge, MAS/N E-3117 N2317VMay-Collier Aviation LLC · Atlanta, GABuilt 1998 · S/N E-3164 N2318ATarpley Gary H · Seaford, VABuilt 1997 · S/N E-3118 N231LCFirst United Inc · Seminole, FLBuilt 1975 · S/N TH-696 N231RLumair LLC · Northville, MIFirst renewal noticeBuilt 1980 · S/N CE-917 N231WEJones Jason Bart · Frankfort, ILBuilt 1980 · S/N TJ-263 N2323ECherokee Beech Boys LLC · Kennesaw, GABuilt 1998 · S/N E3187 N2324AFst Aviation & Logistics LLC · Sheridan, WYBuilt 1997 · S/N E-3124 N2326AValcourt Robert F · Chicopee, MABuilt 1998 · S/N E-3165 N2327AN2327a LLC · Murrells Inlet, SCBuilt 1997 · S/N E-3127 N232FXAvp II LLC · Winnetka, ILBuilt 1993 · S/N E-2772 N232JBLundell Plastics Corp · Odebolt, IABuilt 1973 · S/N CE-448 N232NTorbett Michael G · Lakeway, TXBuilt 1981 · S/N CE971 N232WVLewis And Clark Adventures LLC · Lewes, DEBuilt 1994 · S/N E-2906 N2332JDon M Barron Contractor Inc · Farmerville, LABuilt 1999 · S/N E-3262 N2333BN2333b LLC · Oklahoma City, OKBuilt 1997 · S/N TH-1833 N2333VTytan Holdings LLC · Kalispell, MTBuilt 1998 · S/N E-3183 N2334WBlazek James T · Malta, ILBuilt 1997 · S/N E-3134 N2335KBflyin LLC · Scottsdale, AZBuilt 1997 · S/N E-3135 N2335RPropellerhead Aviation LLC · Santa Cruz, CABuilt 1997 · S/N TH-1835 N2336MHerd James L · Gardnerville, NVBuilt 1997 · S/N E-3136 N2337TPate Jason L · Bedford, TXBuilt 1997 · S/N E-3137 N233AKRoettele Mark · Lake Havasu City, AZBuilt 1991 · S/N CE-1609 N233CKAllen Max · Jefferson, GABuilt 1977 · S/N E-1014 N233CTHoneycutt Danny · Angier, NCBuilt 1984 · S/N TH-1433 N233DFFleckenstein David · Nacogdoches, TXBuilt 1987 · S/N CE1171 N233ESSpain Aviation LLC · Lynchburg, VABuilt 1992 · S/N CE-1683 N233FCPulliam Dan · Baldwin City, KSBuilt 1970 · S/N CE-293 N233JRNorthstar Aerospray Inc · Clara City, MNBuilt 1976 · S/N CE-643 N233LHLetts Jackson W · Kansas City, KSS/N CE-550 N233RPlane Jane Aviation LLC · Sylvania, GABuilt 1975 · S/N D9811 N233SCMattoso Ricardo Q · Spicewood, TXBuilt 1974 · S/N D-9599 N2340APommersheim John Mark · Dulles, VAS/N E-3182 N2342HLakes Treatment Center Inc · Angels Camp, CABuilt 1998 · S/N EA-621 N2343VWischmeyer Jason B Md · Lubbock, TXBuilt 1998 · S/N EA-616 N2345WHanisch Paul J · Crosby, NDBuilt 1998 · S/N E-3188 N2347GSmith Steven L · Whitehall, MTBuilt 1998 · S/N TH-1867 N2347VSomes Jason S · Santa Rosa Valley, CABuilt 1998 · S/N E-3147 N2348QLegha Jaskirat · Holly Ridge, NCBuilt 1998 · S/N TH-1848 N234ABBachteal Paul Shear · Sebastopol, CABuilt 1991 · S/N CE-1562

Back to AD 87-18-06 R1