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.
N55701Level Up Aviation LLC · Newton, ALN55702Seay Horace M · Desoto, TXN55706Camp Justin P · Edwall, WAN5570FCherokee Adventure Corp · Wilmington, DEN5570MFlythebat.Com LLC · Chicago, ILN5570URegistration Pending · Mesa, AZRegistration pendingN5570ZShippers Lee D · Wolcott, NYN55711To Ivan K · Auburndale, FLN55715Ricker Alexander · Spur, TXN55716Norby Aviation LLC · Hopkinton, MAN55719Coffey County Airport · Burlington, KSN5571JHildebrandt Eric A · Cocoa, FLN5571MEdwards Larry N · Saint Joseph, MON5571PDaube Timothy B · Hampton, VAN5571QBerry Charles P · Monroe, NCN5571VColeman Douglas E · Tallahassee, FLN5571ZGlass John · San Luis Obispo, CAN55722Cactus Aero LLC · Haslet, TXN55724Parker David G · Bristol, TNN55726Diedeman Thomas A · Lake City, FLN5572UPoor Farmer Aviation LLC · Saint Marys, OHN5572VWood Charles S · Fox Island, WAN5572ZGilmer Rickey W · Cropwell, ALN55730K&D Ip LLC · Chicago, ILN55731Leary Dennis E · Chesapeake Beach, MDN55736Fox Ralph W II · Wilmington, NCN55738Wenner William E · Kechi, KSN55739Kepfer Robert · Felton, DEN5573QAthens Neurology Professional Association · Athens, TXN5573WHokanson Elijah R · Ashby, MNN5573ZHerrick David · Mont Vernon, NHN55742Doyal William T · Visalia, CAN55743B&R Aircraft LLC · Wadsworth, OHN55744Williams Mike · Hartsville, INN55746Mccoy Michael E · Sanford, NCN5574HAjmi Amal R · Fairbanks, AKN5574MSimpson David B · Oakhurst, CAN5574PPluck Mervyn M · Glendora, CAN5574QDonovan Timothy P · Wichita Falls, TXN5574UCooper Nicholas A · Plano, TXN5574WNordell Ryan J · Roberts, WIN55756Piper Aircraft Inc · Vero Beach, FLN5575FBrewington Jesse L · Glenallen, MON5575JHarrison Matthew · Benton, ILN5575ZLareaux Jon R · Calumet, MIN55761Ramirez Ramon E · Boynton Beach, FLN55763Walker William L · Norfolk, MAN55769Urban Joseph P · Ben Wheeler, TXN5576LMartin Richard W · Raymore, MON5576PMark Stephens Farm Inc · Dutton, MT
Back to AD 81-18-04 R2