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.
N73411Elwood James C · Jupiter, FLN73419Cook Thomas M · Palmer, AKN7341DDunn Steven J · Youngsville, PAFirst renewal noticeN7341GHolmes Omer Lane Jr · Metairie, LAN7341JRicciardi John A · Norwalk, CTN7341PBlaes Richard S · Columbus, OHN7341XRth Enterprise Inc · Wilmington, DEN7341YPond Alex P · Novi, MIN73420Globemaster Services LLC · Saint Jacob, ILN73423Weck Geoffrey E · Woodstock, ILN73424Quincy Flying Club Inc · Quincy, ILN73425Wings Over Texas Holdings LLC · Denton, TXN73428Johnson Brent C · Appleton, MNN73429Anson Flyers Club Inc · Wadesboro, NCN7342JWingate Nicholaus · Lawton, OKN7342LPalmer Ronald E Trustee · Bristol, NHN7342YHinkle Anthony · Mineola, TXN73433Salvation Neighborhood Development Corp · Riverside, CAN73434Monette Verne G · Anchorage, AKN73435Air America Spares LLC · Daytona Beach, FLN73439Umo Flight School LLC · Mount Olive, NCN7343DRautio Mitchell M · Bemidji, MNN7343JSawyer Dean A · Kerrville, TXN7343LAir Dakota Flite Inc · Hettinger, NDN7343WRicht Jerry A · Cleveland, TNN73441Stein Aporn U · Pepeekeo, HIN7344PWorley Jimmy · Dallas, TXN7344WRegistered aircraftN7344YJeffrey P Mcauley Dmd Inc · Midland City, ALN73450Penn Yan Flying Club Inc · Penn Yan, NYN73451Airward Inc · Columbia, CAN73452Hodges Jonathan D · Port Orchard, WAN73453Mfa LLC · Mount Pleasant, SCN73454Yr-Aircraft Leasing LLC · Soldotna, AKN73455101 Flight LLC · Waterford, MIN73456K E F Enterprises · Plymouth, MAN73457Bmg Aviation Inc · Bloomington, INN73459Stowers Joshua S · Niceville, FLN7345GJacks Air Service Inc · Greenville, MEN7345JAlpha 1 Aviation LLC · Helena, ALN7345PGorski Tim B · Larsen, WIN7345ZQuicksilver Air Inc · Fairbanks, AKN73461Monk Crafton L · Saraland, ALN73462Farkas Dan · Wyoming, MIN73464Knight Kevin J · Fort Wayne, INN73468Tnt Airworks LLC · Hibbing, MNN7346GBentley Darrell Howard · Powell, TNN7346JJacobson Daniel · Neenah, WIN73472Lajova LLC · Amarillo, TXN73473Lauro Michael J · Kailua Kona, HI
Back to AD 81-18-04 R2