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.
N9448TSanders Robert · Harlingen, TXN9448WKlein Richard J · Greenville, MIN9449DHall Aircraft LLC · Kenai, AKN9449NCole Vincent J · Ewa Beach, HIFirst renewal noticeN9449VClark Jeff W · Piedmont, MON9449WProfessional Pilots Inc · Lowell, INN944ATerhune Keith B · Crosby, TXN944AAWings Over Texas Holdings LLC · Denton, TXN944AFStanaski Andrew J · Cary, NCN944AKSulphur Creek Helicopters LLC · George West, TXN944BALatitude 18 Helicopters LLC · Lewes, DEN944CBCalifornia Baptist University · Riverside, CAN944CDFlying Easy LLC · Jacksonville, NCN944DPFulton Mark · Elkhorn, NEN944EREmbry-Riddle Aeronautical University · Daytona Beach, FLN944EVSouthlake Aviation LLC · Arden, NCN944GGraves Charles M · Phoenix, AZN944JKRegistered aircraftN944KCMustang Sally Aviation LLC · Camden, SCN944KMMartin Rick H · Las Vegas, NVN944LC4lc LLC · Mcminnville, ORN944MRegistered aircraftN944MALjmf 17 LLC · Hays, KSN944PCAlba Leasing Services LLC · Phoenix, AZN944RRancifer Rodney M · Lithonia, GAN944RRJaybee Aviation Ltd · Fort Mill, SCN944SHA & E Aerial LLC · Nashville, ARN944SJMiller David D · Plainfield, ILN944TDiedrick Michael R · Brooksville, FLN944THSouthern Sky LLC · Henderson, NVN944TLAims Community College · Loveland, CON944TTSoutheast Aircraft Leasing LLC · Jacksonville, FLN944VCoastal 944v LLC · Wilmington, NCN944WMMcinerney James William · Park Ridge, ILN944WTHolt Helicopters Inc · Uvalde, TXN94500Training Planes LLC · Tampa, FLN94505Riverside Flight Center Inc · Tulsa, OKN9450DSharabi Avinoam · Las Vegas, NVN9450WAirwide LLC · Deerwood, MNN94513Hampden Aviation Services Inc · Northampton, MAN9451JJackson James E · Denair, CAN9451LWe Fly High LLC · Helena, MTN9451NHorus Aviation LLC · Ashburn, VAN9451TRegistration Pending · Austin, TXRegistration pendingN9452EDew Jason L · Krum, TXN9452HFreeland Thomas W · Early, TXN9452PRegistered aircraftN9452VFriesen Dwayne Phillip · Overton, TXN9452WMarshall Duane C · Rossville, TNN94532Oklahoma State University · Stillwater, OKFirst renewal notice
Back to AD 81-18-04 R2