AD 87-10-06 R1
Registered aircraft · 72,010
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
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-10-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-10-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-10-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-10-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.
N6956VAbney Timothy R · Crossett, ARN6956YTolsma Michael J · Hawthorne, NJN6957BVaughn James R · Winchester, KYN6957PHoran Edward · Wexford, PAN6957QWashburn Ronald G · Westfield, INN6957VKnoke Keith W · Litchfield Park, AZN6958HJewell Aviation Inc · Kennett, MON6958JAkin Enterprises Inc · Greensboro, GAN6958UVauclin Brady P · Shreveport, LAN6958VSale Reported · Austin, TXSale reportedN6958WPeck Michael S · Las Vegas, NVN6959PSteamboat Express LLC · Sheridan, WYN695APiper Archer Three LLC · Wilmington, DEN695ACHodgson Daniel J · Anchorage, AKN695DTRegistered aircraftN695FParagon Flight Training Co · Fort Myers, FLN695FLPugh Daniel J · Omaha, NEN695LHJrnd Corp · Lewes, DEN695NDFly Gateway Aviation Institute · New Castle, DEN695PMSimonson Robert J · Cedar Crest, NMN695RAPhillips Robert M · Imperial, CAN695RDWerhanowicz Michael K · Hemet, CAN695SDDerek Dunn LLC · Levelland, TXN695XCloud 9 Aviation LLC · Bismarck, NDN6960HZiller Wayne Jr · Fairbury, ILN6960UWayne Brett M · Saint George, UTN6961BTrimmer Marvin E · Willow, AKN6961DOrtega David J · San Antonio, TXN6961JBaja Airventures Inc · Chula Vista, CAN6961QReed Billy B · Cabool, MON6961UMeservey Harley G · Portland, ORN6961VHunt David · Burlington, IAN6961WExpresstek LLC · Farmington, UTN6962JBores Scott J · Huron, OHN6962PSteyn Glen D · Marietta, OHN6962SYeaman John Robert IV · Aroda, VAN6962UGrey Scott A · Bluff City, TNN6962VRez Peter Trustee · Scottsdale, AZN6962WStalnaker Stanley A · Tifton, GAN6963DAbu Trailers Inc · Dwight, NDN6963JFly By Knight Inc · Hammond, LAN6963VBlough Lynn M · Pittsburgh, PAN6963WNash Larry A · Rockport, MAN69641Burke Jason C · Juneau, AKN6964HMor Aviation N6964h LLC · Gaithersburg, MDN6964PEvans Phillip R · Dinuba, CAN6964QSliger Arbie D · Benton, KSN6964ULara Anthony · Manitou Springs, CON6964VDavis Thomas Leigh · Carrollton, TXN6964WKuss John D · Webster, NY
Back to AD 87-10-06 R1