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.
N764NDUniversity Of North Dakota · Grand Forks, NDN7650JAmsg Transport LLC · Southfield, MIN7650KAltherr James H · Fairbanks, AKN7650SMoore Aviation LLC · Westminster, CON7650VNorth Carolina Soaring Association · Zebulon, NCN7651DLehrman Ronald L · Brownsburg, INN7651FAishvaryam LLC DBA · Lancaster, TXN7651PShisler William · Phoenix, AZN7652FProfessional Aviation Aircraft Services Ltd · New Philadelphia, OHN7652JCamilo Rafael Gonzalez Moya · Fort Worth, TXN7652POso Air LLC · Missoula, MTN7652SThrall Gregory D · Seward, AKN7652WCarlson Justin Q · Sheridan, WYN7652YMetro West Ambulance · Hillsboro, ORN7653FHyldburg Aviation Inc · Plymouth, MAN7653JGulley Peter M · Karnes City, TXN7653PThomason Tony L · Williamson, GAN7653RBeech Aviators Of Houston LLC · Kingsland, TXN7653STow Plane Idaho LLC · Boise, IDN7653WHernandez Kelvin · Wilkes Barre, PAN76540Rifle Airshows LLC · Warrensburg, MON7654DDouglas Michael G · Holt, MON7654HAnderson Ayden M · Twin Bridges, MTN7654PCash Shawn R · East Randolph, VTFirst renewal noticeN7654RBeech C23 LLC · Galesburg, KSN7655HKemper Joseph · Coxs Mills, WVN7655WRajh Cody · Chino, CAN7656DBlackford Robert G · Summit Point, WVN7656HStephani Timothy M · White Lake, WIN7656JBurton David N · Pittsgrove, NJN7656KFrankle Joseph Wilder · Arlington, WAN7656PAnkney Gary L · Rector, PAN7656RRobinson Lewis S · Irmo, SCN7656WPchg Aviation LLC · Richmond, UTN7657WCrouse David E · Shrewsbury, MAN7658JGarner Kenneth W · Decatur, ALN7658KJensen Gregory · Johnston, IAN7658SFlytwincos LLC · Las Vegas, NVN7659DJones Emmett F III · Minden, LAN7659FCharles City Aeronautics Inc DBA · Charles City, IAN7659JEdwards Robert B Jr · Macon, GAN7659PStyer David B · Pilot Rock, ORN7659RThomas Chris C · Mansfield, OHN7659WHutain Ronald P · Van Buren, ARN765ACAllen Steven J · Pewee Valley, KYN765AFTuskegee Airmen National Historical Museum · Detroit, MIN765BF4 For Fun Inc · Joliet, ILN765CBJillco Enterprises Inc · Wilmington, DEN765CMLaurel Highlands Helicopters Inc · Latrobe, PAN765FWManduca John M · Overgaard, AZ
Back to AD 81-18-04 R2