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.
N5665ZPerez John-Henry · Locust Grove, GAN56668Pendarvis Damon E · Morrow, OHN5666DHlavnicka Thomas L · Big Sandy, MTN5666PChrysoar Group LLC · King George, VAN5666ZWheeler James R · Falling Waters, WVN56671Cooley Edward B III · Lutz, FLN56673Onward Aviation LLC · Brunswick, GAN56676Paris Air Inc · Vero Beach, FLN56679Worthington Brian M · Saint Albans, NYN5667DWilliams Field LLC · Gig Harbor, WAN5667HLeader Russell J · Glasgow, MTN5667KSmith John L · Renton, WAN5667QLove Phillip Love · Rib Mountain, WIN5667SParsons John C · Wichita, KSN5667WBartanowitz Frank · Millwood, GAN56680Sky III Corporation · Smyrna, TNN56682Hogan David · Simpsonville, SCN56684Hickory Air Associates Inc · Granite Falls, NCN56686Paris Air Inc · Vero Beach, FLN56690Shreeve Michael W · Port Orange, FLN56691Green Brian · Claremore, OKN56694Bruce Robert · Ormond Beach, FLN56695Wassell Aviation LLC · Irwin, PAN56696Sterling Oliver James III · Hancock, NHN5669DMurphey Julian R · Knoxville, TNN5669HUsaviation.Com LLC · Moorestown, NJN5669LGallien Justin A · Livermore, CAN5669NLynn Martin K · Brownsboro, ALN5669PPueringer Matthew B · Britt, MNN5669QMills James A · Dearborn, MIN5669URollins Seth B · Smithville, MSN566BGN566bg LLC · Leesburg, VAN566BSSand Farm Management Services LLC · Adel, IAN566CPCivil Air Patrol · Maxwell Afb, ALN566DDeland Aviation LLC · Deland, FLN566EREmbry-Riddle Aeronautical University Inc · Prescott, AZN566FLSarem Daniel J · Spencerville, MDN566JHRadel Richard L Jr · Bloomsburg, PAN566KAtp Aircraft 3 LLC · Wilmington, DEN566LWMitchell Kevin Cole · Midland, TXN566MTMiddle Tennessee State University · Murfreesboro, TNN566NDCoast Flight Training And Management Inc · San Diego, CAN566QButte Aviation Inc · Butte, MTN566RCJacques Adam P · Weirsdale, FLN566RVCary Steven B · Brookshire, TXN566SPLlp Leasing Group LLC · Lewes, DEN566TPFry Steven G · Eagle River, AKN56701Eros Aviation Ventures LLC · Oakland Park, FLN56703Arthur Gerald J · Riverside, CAN56704Anderson Aviation LLC · Wadesboro, NC
Back to AD 81-18-04 R2