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.
N6426JMunz Dennis F · Prairie Du Chien, WIN6426PCloud Bryan S · Phoenix, AZN6426QSable Jared · Butler, PAN6426USmith Dustin J · Farwell, TXN6426VGlobal Aviators Academy Inc · Claremont, CAN6426YDoyle Thomas E · Hawley, MNN64270Sundance Aviation Inc · Richland, WAN6427LOtt Todd D · Craigmont, IDN6427QAviation Capital Management LLC · San Jose, CAN6427RNortheast Texas Aviation LLC · Chandler, TXN6427UPrecision Pilot LLC · Weston, FLN64280Van Baren Brice P V · Silvana, WAFirst renewal noticeN64281Richmor Aviation Inc · Scotia, NYN64287Wetosha Flying Club Inc · Kenosha, WIN6428JPhillips Roger Dale II · Westfield, NCN6428UGrossman James W · Eureka, SDN6428VDodson International Parts Inc · Rantoul, KSN6428WGeraghty John T · Long Beach, CAN64291Price Kellous A · College Station, TXN64294Eagle Sky Patrol Inc · Deadwood, SDN64296Olmstead Clyde M · Fenton, MIN64297Uptegraff Roy E III · Mc Kees Rocks, PAN64299Hawk Flying Club · Caledonia, MIN6429LMcpherson Joshua R · Oviedo, FLN6429VScott Dean A · Winchester, VAN6429WFarquharson Mark · Hampton, VAN642AWHobart Aviation Inc · Akron, OHN642AZHanson Jake Anthony · Loma Rica, CAN642BKSpetman Craig · Overgaard, AZN642BMEngel Bradley K · Hillsboro, ORN642DGTubular Products Of Texas Inc · Tomball, TXN642FTFlorida Institute Of Technology · Melbourne, FLN642FWSharpe Thomas W · Asheboro, NCN642GDFitzpatrick Timothy Jr · Yerington, NVN642JAYale Companies LLC DBA · Indianapolis, INN642KMNick Heir LLC · Lexington, KYFirst renewal noticeN642LEMason County Aero Club · Ludington, MIN642MDSkydog Aviation LLC · Gainesville, GAN642NDPelican Flight Training LLC · San Carlos, CAN642PSHamer Steven R · Eagle, IDN642RN642r LLC · Farmland, INN642RHValiair Lc Trustee · Casper, WYN642RKKellar Robert J Trustee · Woodbridge, CAN642RSRomeo Sierra Aviation LLC · Sparks, NVN642RVGitlin Joshua · Truckee, CAN642SAFlying Time Llp · Fort Mill, SCN642SBBloomberg David C · Northampton, MAN642SPBlue Sky Aviation Association Inc · Readington, NJN642SWEdgar Thomas L · Flagstaff, AZN642THFairmont State University · Fairmont, WV
Back to AD 81-18-04 R2