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.
N8259WMorrison Daniel S · Hershey, PAN8259YRyan Ferguson LLC · Sanford, FLN825ABAchord James D · Decatur, ALN825ALN825al LLC · Freeport, NYN825CRWolken Ralph E · Shady Shores, TXN825DEYouderian Kenneth E · Coupeville, WAN825DSBreckner Robert J · Burnsville, MNN825ERFlying Aces Aero-Fleet Inc · Guyton, GAN825FGN825fg Corp Trustee · Wilmington, DEN825HBGallegos Joel · Yellville, ARN825KBBrech Robert M · Greenbrier, ARN825KMHusky 5 Kilo Mike LLC · Houston, TXN825KSPlanelease LLC · Venice, CAN825MCC & M Aviation LLC · White Lake, MIN825PBPalm Beach Aircraft Services Inc · Lantana, FLN825PKAia Delta LLC · Henderson, NVN825PMKidd Paul C · Vestavia Hills, ALN825PTIcarus Flyers LLC · Richmond Hill, GAN825RDFrank Richard · West Dundee, ILN825RVSmith Stephen C · Talent, ORN825SHJ L Loewen Md Sc · Niagara, WIN825SWFlying Griffon Aviation LLC · Traverse City, MIN825TJTakeflight LLC · American Fort, UTN82600Hendrickson Ryan H · Gunnison, UTN82603Spain Benjamin D · Opelika, ALN82604Graves Frank C · Nocona, TXN8260NSundberg Nicholas William · Stevensville, MTN8260VRed Rifle Aviation LLC · Richmond, TXN8260YNew Peach Aviation LLC · Brooks, GAN82613Wammen Ranch Llp · Reva, SDN82616Fisher D Bradley · Cleveland, TNN82617Cooper Holly B · Friendswood, TXN82618Lechner Burdette J · Kodiak, AKN82619Cherry Hill Aviation Inc · Freetown, INN8261ECtc Elevated LLC · Heppner, ORN8261GBaer Charles · Terre Haute, INN8261HOxford Flying Club Inc · Oxford, CTN8261PWarzek Mary Ann · Halfmoon, NYN8261SHoffmann David M · Mauston, WIN8261YWilliams Brannon R · Fort Worth, TXN82629Dgf & Associates Inc · Irving, TXN8262ASnider Jay T · Grove City, OHN8262ESee Robert W · Catawba, NCN8262HRegistration Pending · Bucyrus, OHRegistration pendingN8262JHarris James D · Lasalle, CON8262KHesston College · Hesston, KSN8262N40 Flight LLC · Fernandina Beach, FLN8262SWisconsin Aviation - Four Lakes Inc · Madison, WIN8262UHorton Air Ventures LLC · Eustis, FLN8262WCalhoun Jerry H · Washington, NC
Back to AD 81-18-04 R2