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.
N6056WHerfel Kevin R · Middleton, IDN6057HAerospace Trust Management LLC Trustee · Wilmington, DEN6057PAerdonlen · Pensacola, FLN6057QKennedy Kyle R · Berrien Springs, MIN6057WConroy Lance R · Norfolk, NEN6058DJohnson Aaron J · Lewiston, IDN6058FAmeriflyers Of Texas Inc · Addison, TXN6058LMccune William D · Tehachapi, CAN6058WJardine Michael K · Corona, CAN6058ZBlackstone Aircraft LLC · Hartselle, ALN6059DLong Island Aviators LLC · Seaford, NYN6059HOverholtzer Mark S · Salem, ORN6059PShearer Jay E · Coshocton, OHN6059QSchoenleben Thomas J · Stevensville, MTN6059RGlidewell Aviation Inc · Parkland, FLN605ACCullen Brian L · Yuma, AZN605ADBlue Sky Aviation LLC · Great Bend, KSN605CCPatterson Kyle M · Torrington, WYN605EREmbry-Riddle Aeronautical University Inc · Prescott, AZN605FTOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLN605GCareer Pilot Training LLC · Wilmington, DEN605HAEmerald City Aircraft Leasing Inc · Port Orchard, WAN605JTKiefer Matthew J · Xenia, OHN605MAAir Assets LLC · Orlando, FLN605MNSale Reported · Boise, IDSale reported, pending cancellationN605PFBaez Asael · Shillington, PAN605PJL-Bird LLC · Hood River, ORN605RSMegerdoomian Eric · Fort Riley, KSN605RVMalocsay Michael M · Golden, CON605SDMedary Aviation LLC · Brookings, SDN605TCOhtonen Thomas R · Chassell, MIN605WCGyger Keith J · Granbury, TXN605WMZwl Consulting LLC · San Francisco, CAN60603Christiansen Aviation LLC · Wilmington, DEN60605Croft Stanton W · Glenwood, NMN6060DHughes Truman C · Delta Junction, AKN6060FKeller Matthew Charles · Wasilla, AKN6060WNilsen Daniel P · Holmes, NYN60616Mustang Sally Aviation LLC · Camden, SCN6061QThurston David H · Cincinnati, OHN6062ANelson Stephen H · Apple Valley, MNN6062LFoo Flyers LLC · Charlotte, NCN6062PYoung Tracy K · Newcomerstown, OHN6063ELawrence Aviation LLC · Overland Park, KSN6063HHagerstown Flying Club · Williamsburg, INN6063QTaylor Alan M · Nekoosa, WIN6063UStotts Philip H · Capitola, CAN6064DAcadiana Fixed Wing Rotor Wing Inc · Carencro, LAN6064LBohannon Jessica · Tomball, TXN6064QWilliams Rodney K · Stacy, MN
Back to AD 81-18-04 R2