AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N8831NAllen Aviation LLC · Mansfield, MAN8831WForbes Aviation LLC · Boise, IDN88322North County Flight Training Inc · Carlsbad, CAN88329Collins Aviation LLC · Tillar, ARN8832CSale Reported · Coulterville, ILSale reported, canceledN8832JN597w Llp · Arnold, MDN8832LMid Continent Aircraft Corp · Hayti, MON88336Krehbiel Mike A · Gallatin, MON88337Dixon Robert L · Omaha, NEN8833YGagan Samrat LLC · Charlotte, NCN88345Walker Norman K · Anchorage, AKFirst renewal noticeN88348Keller Kelly · Fort Worth, TXN8834CSindelar David C · Franklin, KYN8834YKusnir 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, PAN8835WPashkov Maxim · Los Angeles, CAN88361Robinson Anthony James · Miami, FLFirst renewal noticeN88364Adamson Rex E · Cody, NEN88365Mertens Trusty E · Presho, SDN88368Fitch Keagan M · Philip, SDN8836FWooding William W · Anacortes, WAN8836JSonic Skunk Works LLC · Houston, TXN8836VEast Robert W · Vancouver, WAN8836YLodge Aviation LLC · Lewes, DEN88375Edgar Douglas · Mountain View, MON8837CGoad Graham L · Mcminnville, ORN8837DComanche 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, FLN8838CWhite Edwin J · Avondale, PAN8838JSchlensig Randall D · Anthem, AZN8838PLogan Flyers LLC · Logan, OHN8838WSmith James A · Lyle, WAN8838YWaterwings Seaplanes LLC · Hoover, ALN88395Bryson Robert · Bandon, ORN88397Hunt Daniel R · Hayward, CAN8839888398 LLC · Fremont, OHN8839DHunter Houston W Jr · Marrero, LAN8839JPadgett John E · Austin, TXN8839NCooper Thomas J · Henderson, NVN8839WKarval Fliers LLC · Karval, CO
Back to AD 81-18-04 R2