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.
N950TFAir Fleet Holdings LLC · Missoula, MTN950WKKendall Kristopher W · Denver, CON95105Airbud Aviation LLC · Morristown, NJN9510HRegistered aircraftN9510LCivil Air Patrol Inc · Maxwell Afb, ALN9510PMadsen Travis E · New Underwood, SDN9510QRss Aviation LLC · Myrtle Beach, SCN95111Tiny Tin Aviation LLC · Groveland, FLN9511DEglin Aero Club · Eglin Afb, FLN9511GBurdette Ernest L · Pass Christian, MSN9511JGomez Alexandro · Riverside, CAN9511KMoore Matt R · Nashville, TNN9511MBenjamin Joseph · Erie, CON95121Preston Aviation LLC · Wilmington, DEN9512CDe Aviation Inc · La Porte, TXN9512DFerrell Alan B · Arlington, OHN9512FGeorge'S Aviation Services Inc · Honolulu, HIN9512HTracy Patrick J · Maddock, NDN9512JArapahoe Flight Club LLC · Colorado Springs, CON9512LKreykes K Douglas · Greeley, CON9512MBible Larry · Mount Pleasant, TXN9512SBlack Daniel L · Spicewood, TXN9512UWilkes Jack M · Port Orchard, WAN95133Rd Aire LLC · Opelika, ALN9513BLong Michael A · Grand Lake, CON9513CAgri Business Aviation Inc · Sparta, ILN9513HHigh Flight Academy LLC · Allison Park, PAN9513JGlorioso Richard · Plant City, FLN9513LMott Terry W · Hampton, IAN9513MHangar9llc · Queen Creek, AZN9513PAir Sailing Inc · Reno, NVN95147Ramirez Ricardo A · San Antonio, TXN9514DAdams David D · West Ossipee, NHN9514HFrerichs John E · Gurley, ALN9514JDu Bois Aviation Inc · Chino, CAN9514LBiller Mary Catherine · Columbus, OHN9514MHolen Benjamin E · Ketchum, IDN95151Gonzalez-Pinto Carmelo · San Antonio, TXN95154Cen Inc · Sheridan, WYN95157Smutek Brian D · Mio, MIN9515BGrason Aviation LLC · Appleton, WIN9515DElmer Charles F · Saint Clair Shores, MIN9515JBowman Alex T · Virginia Beach, VAN9515KBoyd Matthew · Hudsonville, MIN9515MReid Stephen M · Gardner, KSN95160Registration Pending · Lakewood Ranch, FLRegistration pendingN9516ESabo John D · New Lenox, ILN9516FKelly David · Issaquah, WAN9516JEastern Kentucky University · Richmond, KYN9516KSmith Dalton L Trustee · Smyrna, DE
Back to AD 87-10-06 R1