AD 94-05-05 R1
Registered aircraft · 26,232
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.
N66197Williams Freddy L Jr · Apo, AEN66199Cunningham Chris S · Hiram, GAN6619ATest Jeffrey T · Port Charlotte, FLN6619ECutrubus C Nina DBA · Ogden, UTN6619GKlenptner Lori Jo · Henderson, NVN6619SFun Flight Training LLC · Bartow, FLN6619THolmes Geoffrey B · Santa Cruz, CAN661ETGorton Peter V · Tucson, AZN661KSWarren Terrance A · Howell, MIN6620AAviation Services Of Tn Inc · Sparta, TNN6620EMccauley Billy R · Cliff, NMN6620FHole In The Clouds Rentals LLC · Montgomery, ALN6620GN6620g LLC · Monticello, INN6620HKline Brad J · Finksburg, MDN6620SFellegy James M · Mauston, WIN6621ERoy Henry M · Carson, CAN66221Anderson Michael · Newbury, MAN66229Biggs Craig C · Severna Park, MDN6622GSky High Adventures LLC · Wilmington, DEN66231Taylor Daniel L · Shakopee, MNN66238Boggs William · Gurnee, ILFirst renewal noticeN66239Star Air Group LLC · Anchorage, AKN6623APardo Lawrence A · Tucson, AZN6623SWilliams Nathan · Von Ormy, TXN6623TSchultz Matthew T · Britton, MIN66243Wainfan Barnaby S · Independence, ORN66244Gray Robert B · Amherst, MAN66245Rio Concho Aviation Inc · Aledo, TXN66247Nunley Joe · Holt, FLN66248Jeffery Anne Kuba · Godley, TXN66249Erickson Keith E · Anchorage, AKN6624EKunzmann Robert · Prescott, AZN6624FJackson Jeffrey G · Kingsport, TNN6624YGay Don A · Garfield, GAN66254Beachy Matthew F · Russellville, KYN6625FManos Norman A · Omaha, NEN66260Schile James · Janesville, MNN66261Gregor John P · Allentown, NJN66268Rahden Tiffany · Bellevue, WAN6626AKrystofiak Steven · Scottsdale, AZN6626FByler Joseph C · Spartansburg, PAN6626NShimkus Stanley M · Irwin, PAN6626SFast Aircraft Aerowork Corp · Miami, FLN66271Registration Pending · Waverly, IARegistration pendingN66273Delgadillo Jose M · League City, TXN66277Mcclure Wayne R · Anchorage, AKN6627AMcgowan Dan J · Springville, CAN6627FLeading Phase LLC · Ham Lake, MNN6627GBelov Konstantin V · Sierra Madre, CAN6627TWalkup Justin · Corpus Christi, TX
Back to AD 94-05-05 R1