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.
N2130HHousley Alfred B · Brownsville, CAN2130MMiles Donald · Columbia, MON2131CJoyce Edward R · Jefferson, OHFirst renewal noticeN2131MSamson Philip C · Nashville, TNN2131VKelley Edward T · Iowa Park, TXN2132VOlson Ethan T · Loves Park, ILN2133ERowan Thomas W · Sterling, AKN2133MCrosswell Joe D · Springtown, TXN2133NRobles Leejay J · Lake Oswego, ORN2133YBullock John E Jr · Birdseye, INN2134YHi Line Flying Club Inc · Seattle, WAN2135GCrawford Mark E · Pleasant Ridge, MIN2135MJames Jeffrey D · Shady Shores, TXN2135NIllogical Aeronautics LLC · Shady Cove, ORN2136VKegin Kevin M · Salem, ILN2137MZewiske Joseph P · Mukwonago, WIN2137YCullinan David · Fryeburg, MEN2138HBowels Larry L · Mcgregor, TXN2139HRay Paul D · Rochester, MNN2139VGrant Michael R · Fort Lauderdale, FLN2140BColvin Clu D DBA · Big Cabin, OKN2141VWiese John C Jr · Palmer, AKN2143VFrederick Albert M · Moultonborough, NHN2145BHorning Richard H · Galion, OHN2145YRegistration Pending · Spokane, WARegistration pendingN2146Bates James L · Lancaster, CAN2146VLyles Jody A · Lake Arthur, NMN2147EJ&Ks Spruce Specimens LLC · Alexandria, MNN2147VVanlierop Keith R · Vevay, INN2147YEast Carolina Aviation LLC · Camden, NCN2149MAutry Lonnie E · San Jose, CAN2149VQuirk Charles L · Lake Charles, LAN2149YTurner Darryl Ray · Copperopolis, CAN214RPSale Reported · Osage, IASale reportedN21505Bagnall Benjamin D · Portsmouth, OHN2150NMellott Christopher · Tempe, AZN2150VSmith Dudley E · Arlington, TXN2151NVoorhis Paul E · Palmer, AKN2151VMerschdorf Albert · East Troy, WIN2152BBolog Keith F · Kenosha, WIN2152YSale Reported · Charlotte, NCSale reported, pending cancellationN2154NPlane Fun Inc Tr Trustee · Snellville, GAN2155YAnderson Thomas K · Miami, OKN21575Registration Pending · Parsons, KSRegistration pendingN2158YN2158y LLC · Pottsboro, TXN2159BRappa Giovanni · Hampton, VAN2159VFers Therese C · Stafford Springs, CTN2159YSmith Joshua · Watertown, MNN215JMMaitland John C · Ashville, NYN2160YOcala Aviation Services Inc · Ocala, FL
Back to AD 94-05-05 R1