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.
N694CRBravo Zulu Aviation Services LLC · Jacksonville, FLN694DBHammond Flying Club Inc · Covington, LAN694DCSweet Dixie Aviation LLC · Reddick, FLN694EDLittle Craig · Santa Rosa, CAN694JSHowell Renny P · Whitehouse, TXN694LHChristiansen Aviation LLC · Wilmington, DEN694MLLindstrom Micah · Milaca, MNN694MPMohill Loren Dell · Murrieta, CAN694PBlack Robert · New Market, ALN694PCBajedi Aviation LLC · Lewes, DEN694PKRule John H · Statesboro, GAN694PSSteger Paul M · Locust Grove, GAN694RRiley James L · Lakeville, MNN694RJAtlas 182rj LLC · Port Townsend, WAN694RMTavel Charles · Cave Creek, AZN694RSSnarr Randy L · South Jordan, UTN694SAMile High Ventures Inc · Palm Harbor, FLN694SMSurveying And Mapping LLC · Austin, TXN694SPFox Leasing Group LLC · Hollywood, FLN694VHall Davis Warren · Mobile, ALN6950BLudwig Henry H · Fort Worth, TXN6950DFaught Jeffrey R · Bismarck, NDN6950PRegistered aircraftN6950RJefferson Airplane LLC · Port Hadlock, WAN6950WEalp LLC · Evansville, INN6951PRossback Jason M · Denver, CON6952BWesley Jerry A · Moorland, IAN6952CSnoz Inc · Sharon, MAN6952HIronfield Jeffrey A · Livermore, CAN6952JLagimoniere Gregory · Jacksonville Beach, FLN6952PBretts Flying Service LLC · Mount Pleasant, MIN6952RMelville Isaiah · Panama City, FLN6952UDuggan Edwin T · Franklin, MEFirst renewal noticeN6952WBeaver Milton H II · Palmer, AKN6952YPorterfield Brian B · Wasilla, AKN6953DLambert Hubert D Sr · Lincolnton, NCN6953JDubois Marcus S · Olive Branch, MSN6953PCianciolo Philip H · Yakima, WAN6953QBrancefield John Lewis · Fort Mohave, AZN6953WScotting David R · Pipestone, MNN6954JHughston Thomas Price · NorfolkN6954PJcav8 LLC · Cartersville, GAN6954QBalash Bryan J · Oldenburg, INN6954VGrubb Jefferson D · Chesapeake, VAN6955DGlover Thomas B · Marana, AZFirst renewal noticeN6955YN6955y LLC · Knoxville, IAN6956BBushplane Lab LLC · Wilderville, ORN6956JJuliet Sky LLC · Sioux City, IAN6956QStaab Robert J · Wantage, NJN6956RMorgan Richard D · Belton, TX
Back to AD 87-10-06 R1