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.
N8349WGrayhawk Flight Training LLC · Lucas, TXN834AMNicholson Scott · Melba, IDN834ATDot Aviation LLC · Wilmington, DEN834CPCivil Air Patrol · Maxwell Afb, ALN834DAb Prop Plane II LLC · Metairie, LAN834DVVeith Donald C · Cattaraugus, NYN834GTIlmberger Stephen R · Sisters, ORN834KTChambers Garland M · Roanoke, VAN834KXHillsboro Aero Academy LLC · Hillsboro, ORN834NDUnd Aerospace Foundation · Grand Forks, NDN834SHSmith Helicopters Inc · Cotulla, TXN834TFAir Fleet Holdings LLC · Missoula, MTN834TTFerreira Mario · New Bedford, MAN834WVVarnedoe Wyman E · Monument, CON8350MVortex Leasing LLC · Racine, WIN8350RPerinoni Edward Jr · Novato, CAN8350VMertz Rachel A · New Ulm, MNFirst renewal noticeN8350WJr Aviation Holdings LLC · Newark, DEN8351Zeller Francis J · Rosamond, CAN83516Airo LLC · Belmont, WIN8351LPlane Junkies LLC · Dover, DEN8351NDel Rio Aviation Inc · Paso Robles, CAN8351PComanche Air Holdings LLC · Austin, TXN8351WQuality Aero LLC · East Aurora, NYN83524Curtis Blake B · Clovis, NMN8352DScarlet Wings LLC · Brunswick, OHN8352LFielding David · Scarborough, MEN8352RQuantum Aviation LLC · Wauna, WAN8352TFlight Inc · Lakewood, CON8352WLebanon Flying Club · Lebanon, MON8352YSkylandsair LLC · Port Orange, FLN83539Silbersiepe Thomas E · Catlett, VAN8353COstwinkle Jeffrey J · Justin, TXN8353DKauffman Land & Development LLC · Fort Lupton, CON8353HThompson Rufus · Oceanside, CAN8353MCrosswind Leasing LLC · Prescott, AZN8353RSchrandt Mark L · Shoreview, MNN8353VN8353v LLC · Monroe, LAN8353WN8353w Flyers LLC · North Las Vegas, NVN8353YSoutheast Leasing LLC · Delray Beach, FLN83540Red Tail Scholarship Foundation · Tuskegee, ALN83545Mayeur Clint · Wasilla, AKN83549Giacometto John T · Broadus, MTN8354CTayab Farooq · Allen, TXN8354JOld Buzzard Aviation Inc · Middleburg, FLN8354LEast Texas Imperial Petroleum LLC · Flint, TXN8354QKandravi Enterprises Inc · Centereach, NYN8354RStonebrink Grant · Boonton, NJN8354WCoombs Eric S · Louisburg, NCN8354YMiles Dan · Saint Augustine, FL
Back to AD 81-18-04 R2