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.
N860SASaint Clair Flight Academy Inc · Richmond, MIN860SCFf22 LLC · Scottsdale, AZN860SPRegistered aircraftN860TCNorth Star Aviation Inc · Mankato, MNN860UBoard Of Regents Of The University Of Oklahoma · Norman, OKN8610NSkipper Donald J · Huntersville, NCN8610PTapert Warren F · Lenox, MIN8610RTener Dean R · Lisbon, OHN8611VAlbright Harold R · Dubois, WYN8611WSheppard Travis · Terrebonne, ORN8611YCragg Gordon E · Georgetown, TXN8612DPerry Leonard M · Soldotna, AKN8612PFranz James T · Glendale, AZN8613DPerry Kenneth V · Katy, TXN8613VBoley Trevor T · Palmer, AKN8614NFarmers Bank Of Northern Missouri Na · Unionville, MON8614PLee Patrick J Jr · Lindstrom, MNN8614WRegistration Pending · Grand Junction, CORegistration pendingN8614YD&D Maintenance LLC · Etna Green, INN8615VCitabria N8615v LLC · Westminster, CON8615WJefferson Community & Technical College Foundation · Louisville, KYN8615YUniversity Of Alaska Anchorage · Anchorage, AKN8616DFrancis Harvey B · Key West, FLN8616VPittman Michael · Goodridge, MNN8616WKlopsch Steven J · Colbert, WAN8617DGrisham Michael H · Paulden, AZN8617HToutant Roland J · Woodstock, CTN8617PFrisbie Kevin R · Fairfield, IAN8617WHacker George A · Renton, WAN8617YBurton David A · Pepperell, MAN86183J L Air LLC · Wilmington, DEN8618LLatimer Lawrence A · Vernon, TXN8618YGroup Aire II · Manitowoc, WIN86198Styer David B · Pendleton, ORN8619ACowboy Up Aviation LLC · Frenchglen, ORN8619DBenton Mark H · Sussex, WIN8619EHogan Daniel L · Chapel Hill, NCN8619LAerial Banners Inc · Pembroke Pines, FLN8619PStewart Mark A · Mccall, IDN8619VPlane Folks LLC · Tucson, AZN8619YNuse Aviation LLC · Hollidaysburg, PAN861ACGuglietta Glenn W · Payson, AZN861APKlein Edwin Andrew Bell · Grass Valley, CAN861BABarr Air Patrol LLC · Mesquite, TXN861CDHansell David A · Windsor, CON861CHPope James D · Lewiston, IDN861MMGiordano Matthew J Jr · Wilmington, DEN861PProfessional Training Aircraft LLC · Wilmington, DEN861SFAircraft Guaranty Corp Trustee · Oklahoma City, OKN861VLVieques Air Link Inc · San Juan, PR
Back to AD 87-10-06 R1