AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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.
N175NSNovember Sierra Aviation LLC · Oneill, NEN175PBurdick Rich · Montrose, CON175PDD'Artenay Craig A · Coalinga, CAN175RBurdick Rich · Montrose, CON175RJSwanson Matthew I · Wasilla, AKN175SHSmith Edward · Lecompton, KSN175SMWhitley Steven · Auke Bay, AKN175TAAnderson Tracy E · Houston, TXN175TBSalyer Robert D · Nashville, TNN175TGMoschetti Flight Outfitters LLC · Kingston, WAN175THLa France Edward J · Ellensburg, WAN175UKChase Michael E Trustee · Montague, MIN175VCCashmere Aviation LLC · Mcalester, OKN175WRMcgraw Jeff M · Denver, CON1760FPark Rapids Avionics Inc · Park Rapids, MNN1761FTuttle Trent · Deforest, WIN1761KGrant Cynthia S · Austin, TXN1761NNewcomer Ryan D · Monroe, GAN1761VMoyer Michael R · Elkton, MDN17637Pridgen Blaine D · Breaux Bridge, LAN1763EKohn Michael E · Endicott, NYN1764KMurray Gregory T · Napa, CAN1765FKohler Daniel J · Mapleton, ORN1765KNesmith Matthew D · Marietta, GAN1766NStevens William · Nassau Bay, TXN1767KRegistration Pending · Clancy, MTRegistration pending, pending cancellationN1767VHanson Jonathan G · Nome, AKN1768QHarper John T · Fairfield, OHN1769QPmn Enterprises LLC · Fremont, WIN1770ESimmers Jonathan P · Mandan, NDN1770KFlip Turn LLC · Washington, DCN1770NWirth Curtis L · New Raymer, CON1771EBerntsen Bradley T Trustee · Apple Valley, MNN1771NRohsner Thomas A · Nacogdoches, TXN1772FTia Aviation LLC · Hot Springs, ARN1773DReeves Stephen E · Palm Harbor, FLN1773FRegistration Pending · Jasper, ALRegistration pendingN1773KJasinski Jack J · Necedah, WIN1773NRhoades William P · Northfield, MNN1773VGilbert Mary L · Memphis, NYN1774FBarnstormers Aero Services Inc · Lompoc, CAN1775NPritchard Joshua E · Andover, KSN1775QBrooks Timothy J · Oshkosh, WIN1776DRobbins Flight Training LLC · Bakersfield, CAN1776KRodney William Debaun Family Lp · Midlothian, TXN1776VNelson Richard W · Edna, TXN1778BBrosette Victor N · Dallas, TXN1778FBlake Brian R · Irvine, CAN1778VWatkins James R · Granbury, TXN1779DSchrag Jeremy M · Garden Plain, KS
Back to AD 94-05-05 R1