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.
N7156QAmerican Patrols Inc · Midland, TXN7156RBlair Marianne T · Waynesboro, VAN7156ZClum David V · Anchorage, AKN7157BOwyhee Aviation LLC · Provo, UTN7157DNewgent Isaac T · Westminster, MDN7157GAero Quest LLC · Olive Branch, MSN7157LZuwerink Michael J · Holton, MIN7157USl Motorsports Inc · Paradise Valley, AZN7157YTailwind Consulting LLC · Port Orange, FLN7157ZUrstadt Christopher M · Girdwood, AKN7158CAeronauts Flying Club Inc · Newton, MAN7158DTotal Flight Aircraft Leasing LLC · Apex, NCN7158GHawk Aviation Inc · Rush City, MNN7158LSears Wes L · Tacoma, WAN7158PJinnette James · Raleigh, NCN7158RVenango Regional Aero Group Inc · Franklin, PAN7158SHawaii Pacific Aviation Inc · Kailua Kona, HIN7158UMenjivar Christian J · Missoula, MTN7159GN7159g LLC · Jacksonville, ARN7159LRowlett Roger S · Hamilton, NYN7159PAdams George D · Franklin, INFirst renewal noticeN7159UChamberlain Gary M · Challis, IDN7159WBami LLC · Clymer, PAN7159YPepmiller Scott C · Panama City Beach, FLN715AGGreen Allen R · Westminster, CON715AMVon Graff Kurt · Pennington, NJN715APKayir Yohannes · Pensacola, FLN715BBMartin L Jeffrey · Hudson, OHN715BFPlante Dennis M · Woodway, TXN715CPCivil Air Patrol · Maxwell Afb, ALN715CWWoodin Christopher · Groveland, FLN715DFAerospace Trust Management LLC Trustee · Wilmington, DEN715FLTaylor Kennedy F · Courtland, MSN715GHodge Cle'Jae J · St Thomas, VIN715HPOhio Department Of Public Safety · Columbus, OHN715JN873sa LLC · Fort Lauderdale, FLN715LGGuy Transportation Ltd · Carolina, PRN715LMIntepros Inc · Jupiter, FLN715MBS&M Aircraft LLC · Harmony, PAN715MRLeone Michael A Sr · Collinsville, OKN715PAArchambault Leon P · Littleton, MAN715PSMohamed Shamim · San Francisco, CAN715RRegistered aircraftN715RBFirst Love LLC · Sterling, AKN715RCEide David B · Saint Michael, MNN715RJOsler Chris R · Spokane, WAN715SBDahmes Ronald M · Eagan, MNN715SCRunamuck LLC · New Orleans, LAN715WDGillispie Wayne A · Grayson, KYN7160DDrain Alan K · Columbus, MT
Back to AD 87-10-06 R1