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.
N78238Weaver William B · Vancouver, WAN78239Draco Flight School DBA · Chino, CAN7823DBurnopp Jacob A · Evington, VAN7823GAmerican Patrols Inc · Midland, TXN7823HCharley Arrie · Gakona, AKN7823NKaiten Aviation LLC · North Haven, CTN7823VNelson Brent E · Richland, WAN7823WCdm Dirt LLC · Snowflake, AZN78240Kinney Joan M · Vermillion, SDN78242176fps LLC · Marthasville, MON78249Howard Ronald W · Okeechobee, FLN7824CRegistered aircraftN7824DWhitaker Samuel M · Brooklet, GAN7824NMcatarian Mark F · Saint Marys, KSN7824TRoss Charles · Midlothian, TXN7824VLyon Timothy P · Kansas City, MON7824WHornbill Aviation LLC · Incline Village, NVN78253Chatman Hannah K · Poplar Bluff, MON78254Bpk Holdings LLC · Montesano, WAN7825ND&D Vision Air LLC · Aubrey, TXN7825VHenderson Randy G · Williamstown, WVN7825WNelson Aaron D · Carver, MNN7826681 Escadrille Inc · Hutchinson, KSN7826VUse Your Call Sign Holdings LLC · Kalispell, MTN7826YInternational Air Services Inc Trustee · Carson City, NVN7827CKestrel Aviation LLC · Reno, NVN7827DThree Legged Hog Aviation LLC · Boise, IDN7827NBest John P · Goldsboro, NCN7827PRowan Christopher James · Sparks, NVN7827SStar Aviation Inc · Melville, NYN7827VJaffe Michael R · Terrell, TXN7827WWoods Perry H · Brownsville, TXN7827YEpton Richard Charles · Senoia, GAN78286Marsh David J · Sioux Falls, SDN7828DDyer Royal J · Melrose, NYN7828NBurris Jamey E · Mt Juliet, TNN7828PBvv Aviation LLC · Ben Wheeler, TXN7828VHam Henry P · Saint Louis, MON7828WIliff Aircraft Repair And Service Co Inc · Tulsa, OKN7828YVan Laak James E · Poquoson, VAN78295Cofsky Gregory J · Sandwich, MAN78299Jb Aircraft LLC · Anchorage, AKN7829GKilo Sierra Aviation LLC · Sammamish, WAN7829NRoth Colin E · Anchorage, AKN7829PSpring Mountain Technologies LLC · Schwenksville, PAN7829VAirdad LLC · Houston, TXN7829WBormann Charles F · Mooresville, NCN782AN782a Leasing LLC · Linden, MIN782CAChristman Matthew T · Markle, INN782DEBoard Susan W · Moundsville, WV
Back to AD 87-10-06 R1