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.
N88309Larkin Edward C · Covington, KYN8830JAnderas Per R · Green Bay, WIN8830LKolb Austin · Phoenixville, PAN8830PCanon Daniel H · Fruit Cove, FLN88311Nelson Jayson L · Glasgow, MTN88312Bayou Dusters LLC · Moreauville, LAN88314N88314 LLC · Louisville, CON88315Uscola Merle J · Wasilla, AKN8831BBergeson Michael S · Cottage Grove, MNN8831MMcmeekin Robert R Jr · Bethesda, MDN8831NAllen Aviation LLC · Mansfield, MAN8831WForbes Aviation LLC · Boise, IDN88322North County Flight Training Inc · Carlsbad, CAN88329Collins Aviation LLC · Tillar, ARN8832JN597w Llp · Arnold, MDN8832LMid Continent Aircraft Corp · Hayti, MON8832PRoundtree Benjamin · Cass City, MIN88337Dixon Robert L · Omaha, NEN8833PRegistered aircraftN8833VMeyr Richard J · Reno, NVN8833YGagan Samrat LLC · Charlotte, NCN88345Walker Norman K · Anchorage, AKFirst renewal noticeN8834YKusnir Michael A · Niles, MIN88350Downs Jeremy H · Wichita Falls, TXN88351Cosentino Allen P · Templeton, MAN88352Morris Charles R III · Charlotte, NCN88353Amelia Reid Aviation LLC · San Jose, CAN8835DBrocke Rodney A · Bay City, MIN8835FUniversal Exports LLC · Schuylkill Haven, PAN8835PFeller James P · Granite Bay, CAN8835WPashkov Maxim · Los Angeles, CAN88364Adamson Rex E · Cody, NEN88365Mertens Trusty E · Presho, SDN88368Fitch Keagan M · Philip, SDN8836FWooding William W · Anacortes, WAN8836JSonic Skunk Works LLC · Houston, TXN8836YLodge Aviation LLC · Lewes, DEN8837DComanche Bloom Enterprises LLC · Purcellville, VAN8837JJerry Wachtel N · Carleton, NEN8837NAlpha Kilo Aviation LLC · Wasilla, AKN8837YWilfly Inc · Dahlgren, ILN88382Macconnell John W · El Dorado, CAN88384Wingit Holdings LLC · Mannford, OKN88385Skywords Advertising LLC · Lantana, FLN8838JSchlensig Randall D · Anthem, AZN8838PLogan Flyers LLC · Logan, OHN8838WSmith James A · Lyle, WAN8838YWaterwings Seaplanes LLC · Hoover, ALN88395Bryson Robert · Bandon, ORN8839888398 LLC · Fremont, OH
Back to AD 87-10-06 R1