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.
N7112GHooper Walter E III · Spring City, TNN7112KHamann Hunter R · Spokane, WAN7112LDoskicz Harry N · Slatington, PAN7112PNouri Kamyar · Fullerton, CAN7112RMarshall Air LLC · Bellevue, MIN7112WKeesee Bill · Meadow, TXN7113DN7113d LLC · Ardmore, OKN7113LBlanton Ronald · Lascassas, TNN7113PWallace Lonnie Roy · Charlotte, NCN7113QMiles Michael G · Hillsborough, NCN7113RNewton Dennis E · Surprise, AZN7113WHigh Flyers Inc · Benson, AZN71141Av8 Flight Assets LLC · Eden Prairie, MNN71143Av8 Flight Assets LLC · Eden Prairie, MNN7114AMy Air Mira LLC · Eagan, MNN7114BShore Brian R · Carmichael, CAN7114CAv8 Flight Assets LLC · Eden Prairie, MNN7114DPierce Brian L · Grants Pass, ORN7114JAv8 Flight Assets LLC · Eden Prairie, MNN7114PP & G Aviation LLC · Omaha, NEN7114QSass Kenneth · Charlotte, NCN7114RUniversity Of Alaska Anchorage · Anchorage, AKN7114UMaximizing Abilities Through Training Two DBA · Independence, MON7114VCross Wings Aviation LLC · San Antonio, TXN7114WEstes Shannon L · Pace, FLN7114YAymerich Marc · Belvedere, CAN7114ZSchwend Brian · Forsyth, MTN7115LAtp Aircraft 3 LLC · Wilmington, DEN7115PKutner Michael S · Nichols Hills, OKN7115QMaggart Kenneth R · Lutz, FLN7115WLambert Scott E · Shamong, NJN7115YMcdade Nimrod R III · Smyrna, TNN7116DSeelinger Donald P · Seldovia, AKN7116QStogner Sarah E · Monahans, TXN7116RBastian Dennis L · Burns, WYN7116VPeterson Robert E · Mobile, ALN7116YSinclair Air LLC · Shallowater, TXN7117BSale Reported · Chelsea, MISale reportedN7117EDowell Cameron C · Solomons, MDN7117GBaker Brady B · South Hero, VTN7117PRegistration Pending · Sandia, TXRegistration pendingN7117VNrv Flyers Inc · Blacksburg, VAN7117WMitchell Cameron A · Hopkinsville, KYN7118PSuarez Aaron M · La Habra Heights, CAN7118QMartin Stephen T · Green Cove Springs, FLN7119BDelaney Patrick J · Marion, TXN7119DBuell Travis · Harper, TXN7119MSutton Aircraft Salvage LLC · Palmer, AKN7119PLowry Wilson R · Leonardtown, MDN7119UTtwn Media Networks LLC · New York, NY
Back to AD 87-10-06 R1