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.
N65413John Mccaskill Enterprises LLC · Tifton, GAN65415Cal Aggie Flying Farmers Inc · Davis, CAN65417Frear Robert · N Redngtn Bch, FLN6541LOse Leroy B · Thief River Falls, MNN6541URegistered aircraftN6542HOwens Flight Training LLC · Lafayette, LAN6542PSmith Noland F Jr · Chattanooga, TNN6542VHarris Dakota · Goose Creek, SCN6542WBaird Philip D · Judith Gap, MTN6542ZKingsley Kiman J · Miller, MON65435Wings Over Texas Holdings LLC · Denton, TXN65439Pnl Aero LLC · Raleigh, NCN6543DBatte Randall E · Forest, MSN6543UGiesey William · Philadelphia, PAN6543VChupito Sabrocito LLC · Paso Robles, CAN6543WJts Aircraft LLC · Rock Hill, SCN65440G&M Aircraft Inc · Wheat Ridge, CON65447Maxxum Financial Group Inc · Destrehan, LAN65449Hoeft Cliff A · Pilot Rock, ORN6544AMatthews Aviation LLC · Hardinsburg, KYN6544KWaldron Ronald J · Strongsville, OHN6544LPencoe Glenn L · Jemison, ALN6544TCourtney John T · Woodbridge, CTN6544WBrown Rayford K · Temple, TXN6545365453 LLC · Blaine, MNN6545DCosta Flying Service Inc · Painted Post, NYN6545GBoomer Aviation Inc · Fort Walton Beach, FLN6545HAmerican Patrols Inc · Midland, TXN6545RBonilla-Cruz Carlos · Houston, TXN65468Burger John J · Ocala, FLN6546FMiljour Jack A · Sanborn, NYN6546UBadlands Flyers Inc · Watford City, NDN65470Jt Aero LLC · Wilmington, DEN65471Overland Aviation LLC · Williston, NDN65472Registered aircraftN6547JMeyer Mark A · Vass, NCN6547SMiller Bradley J · Joliet, MTN6547WMacclements Jonathan E · Austin, TXN65483American Aviation Inc · Brooksville, FLN65489Flight Solutions LLC · Columbia, MON6548ESewell William G Jr · Bremen, GAN6548JInspire Aviation LLC · Magnolia, TXN6548LJudge Christopher E · Vacaville, CAN6548PPettus Gary A · Fort Mill, SCN6548VMaxwell Frank R · Fairbanks, AKN6548ZKingsley Kiman J · Miller, MON65495Circle W Flying Club Inc · Creighton, PAN65498Wings Over Texas Holdings LLC · Denton, TXN65499Pacific Quality Controls Inc · Wrightwood, CAN6549DBbjs Investments LLC · Waukesha, WI
Back to AD 81-18-04 R2