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.
N841GRegistration Pending · Painter, VARegistration pendingN841JARicci Theodore J · Spotswood, NJN841JWScenic Concepts LLC · La Crosse, WIN841KSKansas State University · Salina, KSN841LMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN841LSAnderson Paul N · Edmond, OKN841MBAircraft Guaranty Corp Trustee · Oklahoma City, OKN841MCSouth Bay Aviation Leasing LLC · Gardena, CAN841NDUnd Aerospace Foundation · Grand Forks, NDN841NHMarrs Matt · Bentonville, ARN841PGeeslin James W Jr · Sterling, AKN841RSVintage Pursuits LLC · Crestwood, KYN841RVPotter Robin B · Southport, NCN841TMJet Aviation LLC · Commerce Township, MIN84205Mitchell Myron · Advance, NCN84209Arwood Ralph Trustee · Naples, FLN8420BSplash & Go Seaplanes LLC · Miami, FLN8420CRegistered aircraftN8420DAlsworth Glen R Sr · Port Alsworth, AKN8420JGimple Herman Wm · Greenville, CAN8420LHayhurst Shane R · Winfield, PAN8420RMueller Lance · Milton, DEN8420WMckee Shane D · Fairbanks, AKN8420YVanwarmerdam Leslie C · Nampa, IDN84210Pm Jets LLC · Ashland, OHN84214Planefully Obvious LLC · Oshkosh, WIN8421AKing Air Inc · Naknek, AKN8421DPutman Bruce C · Leonard, MIN8421JRegistered aircraftN8421RRoberts Darren C · Zionsville, INN8421YKesser Gilbert M · Culpeper, VAN84221Mcknight Michael D · Marietta, GAN84224Cordes Jeffrey A · Happy Valley, ORN84225Executive Flight Institute LLC · Murrieta, CAN84226Jackson County Aviation LLC · Sneads, FLN84227Jernigan Alex E · Warrensburg, MON84229Langenbahn Theodore John · Schoharie, NYN8422HDeevers Howard A · Tucson, AZN8422LHubert Kim J Trustee · Eagle River, AKN8422MDymond Mark S · Monterey, TNN8422NCenter Flying Inc · Lancaster, CAN8422RTascarella William M · Quakertown, PAN8422W642 Flying Club Of Fort Worth Inc · Fort Worth, TXN84234Mazelg Aviation LLC · Bartow, FLN84235Klj Air LLC · Fairless Hills, PAN8423DKearney Rick G · Amity, PAN8423LYoung James A · Toledo, WAN8423PAdams Mark · Sumter, SCN8423WGillanders Kenneth William · Carson City, NVN8424Huston Charles D · Austin, TX
Back to AD 81-18-04 R2