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.
N8291ERangers Flying Club Inc · Eden Prairie, MNN8291JWorth William A · Anthony, NMN8291NPeters Rodney A Jr · Hayward, WIN8291PWilcher Trevor C · Macungie, PAN8291WVoll Dorothe A · Corona, CAN82921New Hampshire Flying Association Inc · Nashua, NHN8292DHuffman Jacob M III · Burleson, TXN8292EP&N Corp · Marion, IAN8292JBrent Scott Properties Lp · Eagle, CON8292PCharles City Aeronautics Inc · Charles City, IAN8292TJames Peterson Sons Inc · Medford, WIN8292WPinegar Kevin R · Brighton, MIN82933Cummings Jake A · Tucson, AZN8293CMcchargue Robert W II · Talkeetna, AKN8293EFiorini Anthony Wayne · Tuttle, OKN8293NPaul Harvey B · Kongiganak, AKN8293PGrosshans Inc · Central City, NEN8293RPanterra Aviation LLC · Mountain Green, UTN82942Kemp Kerm R · Southwest Ranches, FLN82945Brewer William B Jr · Fairbanks, AKN82946Class A Coaches LLC · Missoula, MTN82947Mann Jacob A · Wheatland, WYN82949Mcbride Peter M · Basalt, CON8294HSidney Aviation LLC · Sidney, NEN8294JDowning John T · Tucker, GAFirst renewal noticeN8294KAdvantage 94 Kilo LLC · Grosse Pointe Park, MIN8294LAts Tennessee Inc · Oneida, TNN8294YNenno Richard W II · Bothell, WAN82951Av Enterprises Inc · Bozeman, MTN82953Sky Fox Aircraft LLC · Queen Creek, AZN82956Holmes James E · Klamath Falls, ORN8295EFrump Leasing Inc · Newburgh Heights, OHN8295HAnywhere Atp LLC · Mt Juliet, TNN8295NMaust Philip J · Hemet, CAN8295TFlight Services Inc · Headland, ALN8295WHess Stephen L · Millerton, PAFirst renewal noticeN8295ZWhitaker Stephen P · Northville, MIN82961Montgomery Daniel G · Wasilla, AKN82962Jacques Jerry J · Iliamna, AKN82965Mockingbird Flying Club · Sioux Falls, SDN82967Spare Joseph T · Waldo, OHN82968Pulse Jeremy D · Moore, MTN82969Feriani Ralph B · Anchorage, AKN8296EMosbach Rene A · Sandia, TXN8296JVarga Aircraft Co · Hephzibah, GAN8296NCline Terence P · Alva, OKN8296PBarto Eric K · Kula, HIN8296WAngert Phillip E · New York, NYN8296YBl Aviation Services LLC · Camden, DEN82972Supercub LLC · Anchorage, AK
Back to AD 87-10-06 R1