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.
N965JDCircling Sky Aviation LLC · Canton, MSN965LTUniversity Of La System DBA · Ruston, LAN965MAFirst Aero Group LLC · Wilmington, DEN965MMBastian Devan · Vernal, UTN965MSMt San Antonio College · Walnut, CAN9660BHenry Lawrence D · Lohman, MON9660HCdb Group Holdings LLC · Sheridan, WYN9660MKnight Aviation LLC · Comanche, OKN9660PCook Timothy L · Eagle River, AKN9660SHughes Alan J · Edison, OHN9660WAlaimo Thomas J · Napa, CAN96616Air Transport Inc DBA · Las Vegas, NVN9661JGrant Michael T · Eugene, ORN96621D Gordon Aviation Inc · La Jolla, CAN96626Wingsleasing LLC · Wichita, KSN96628Bobby Nelson Aviation LLC · Kettering, OHN9662MPotter Colin · Piedmont, SDN9662QHomiller Robert S · Bear, DEN9662UT & J Services Inc · Wilmington, DEN9662VLevel X Aviation LLC · Royal Palm Beach, FLN9663DRamsey Bobby W · Harrogate, TNN9663JN9663j LLC · Dallas, TXN9663LPhlindy Investments LLC · Eagle River, AKN9663PDilse Brian R · Grand Forks, NDN9663UMaxfield Ronald · Mechanicsville, VAN9664MProvide It Air Solutions LLC · Tampa, FLN9664PYundt Joshua J · Wasilla, AKN9664UBoan Timothy C · Berryville, VAN9665FFranklin Charles L · Athens, ALN9665HDouble Bridges Aviation LLC · Enterprise, ALN9665JUmbarger Brian T · Shawnee, KSN9665MMr Aviation Group LLC · Mifflintown, PAN9665QAlldredge Aviation · Auburn, WAN9665SDendy Dwight E · Caledonia, ILN9665UDurning Robert · Riddle, ORN9665VAircraftsmen LLC · Heber City, UTN9665WSoto Osvaldo · Myersville, MDN9666DWing Robert E · Fairbanks, AKN9666HMorton Tamera L · Belpre, OHN9666PKenmore Air Harbor LLC · Kenmore, WAN9666UGlass Gene A · Lafayette, LAN9666VMedia Stew LLC · Carson City, NVN9667DAppling Justin Glenn · Amarillo, TXN9667JKidd James Allen · Owasso, OKN9667LPelot Samuel Boykin Jr · Sebring, FLN9667PNigus Brett Alan · Fairbanks, AKN9667SJones Larry C · Clovis, NMN9667UBeall James C · Hollywood, SCN9667VWilliams Burla L · New Cumberland, WVN9668CBrandywine Flight School Inc · West Chester, PA
Back to AD 81-18-04 R2