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.
N9643MExquisite Aviation Inc · Coachella, CAN9643QLeading Edge Flight Academy LLC · Bend, ORN9643STurner Nathan D · Nenana, AKFirst renewal noticeN9643URazink Ted · Starbuck, MNN9643VBrazos Valley Flight Services LLC · College Station, TXN9643WN9643w LLC · Dover, DEN9644CBybee John E · Burlington, IAN9644JLeckliter Michael A · Murrieta, CAN9644KLuck Aviation LLC · Glen Allen, VAN9644LHaas Larry W · La Cygne, KSN9644MBurley Joseph D · Fayetteville, GAN9644QSkyhawks Inc · Chippewa Falls, WIN9644SClausen Robert G · Argyle, MNN9644UBrannan James E · Fresno, CAN9645DDarryn Allyson R · Las Cruces, NMN9645HSantiago Diana L · Juana Diaz, PRN9645JLuxury Vacations Inc · Scottsdale, AZN9645UKiebke Heather A · Detroit Lakes, MNFirst renewal noticeN9645VOak Ridge Flyers Inc · Oak Ridge, TNN9646BN9646b LLC · Wilmington, DEN9646DFerrell Alan B · Arlington, OHN9646RB-Dog Aviation LLC · Grand Junction, CON9646WOgier Gerard Paul · Hampton, NHN9647BLakewood Investments LLC · Victorville, CAN9647DSutton Neal · Ashby, NEN9647MSoaring Eagle Flying Club · Midland, MIN9647QKaeni Law Group Inc · Santa Ana, CAN9647SGarrett Flying Service · Danbury, TXN9647UWilhite Randall D · Plainville, MAN9647WAirplanes Plus Inc · Marathon, FLN9648BBarker David C · Lumberton, NCN9648HSaunders Larry F · Sulphur Springs, ARN9648MN9648m LLC · Louisville, KYN9648QGreen Bay Flying Club Inc · Krakow, WIN9648USmith Edward T · Black Diamond, WAN9648VGrove Kaylene · San Diego, CAN9648WMccullough Dwayne D · Onancock, VAN96493Smtm Holdings Inc · Wilmington, DEN9649BGoebel Christian E · Luray, VAN9649DUlrich Kenneth B Jr · Kingwood, TXN9649JRegistration Pending · Springboro, OHRegistration pendingN9649LGulfstream Aerospace Corp · Savannah, GAN9649PHarris Hill Soaring Corp · Horseheads, NYN9649SHowell Alice R · Bainbridge, GAN9649VLagorce Victor X · Owasso, OKN9649WWard Travis E · Tucson, AZN964AAFlorida Flight Training Center Inc · Venice, FLN964ABSmith Craig W · Horton, MIN964AC63 Victor LLC · Fremont, OHN964ALMay Robert E · Payson, AZ
Back to AD 81-18-04 R2