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.
N5353CStill Martin L · Upper Sandusky, OHN5353QRegistered aircraftN5353TRegistration Pending · Covington, GARegistration pendingN5355CRothstein Steven R · Punta Gorda, FLN5355RFeauto Aviation LLC · Saint Cloud, FLN5356C56 Charlie LLC · Bloomington, INN5356TVan Natta Richard C · Lusby, MDN5358RVandenbosch Joseph P · Bergen, NYN5359Q620 Stanley Aviation LLC · Meridian, IDN5359TJanssen Glenn L · Lakewood, CON535BAAdkins George W · Meridian, MSN535DBMansfield David E · Ashland, KYN5360RSommer Wayne · Wellsville, MON5360TCurran Ronald J · Olympia, WAN5361QBushre David N · Janesville, WIN5361TDick Ronald J · Fort Wayne, INN5362QHelderman Curtis L · Newton, NCN5362RWeinhold Dale J Trustee · Ellsworth, KSN5363CAffiliated Equipment Leasing LLC · New Castle, DEN5363RCrawford James A · Coshocton, OHN5364CFischer James E · Lakeville, MNN5364TKato Matt J · Fairbanks, AKN5365AWest James B · Star City, ARN5365CKlotz Terrance M · Sparks, NVN5365TLaperle Aviation LLC · Colebrook, NHN5366TTbl Aviation LLC · Springfield, ORN5366UWhite Mark L · Vero Beach, FLN5367CAv8rs LLC · Gig Harbor, WAN5367QLeatherneck Aviation LLC · Billings, MTN5367RBrooks Gordon B Sr · Hot Springs, SDN5367TJulian Farm LLC · Hudson Oaks, TXN5368QMobley Christopher M · Keysville, GAN5368RBiggs Aircraft Inc · Wellston, OKN5369CLowe David · Sacramento, KYN5369QAirfleet Solutions LLC · Newark, DEN536CSHeaton Mark A · Gasquet, CAN536DWMoretti Anthony M · Deming, NMN5371LKamel Lance J · Plantation, FLN5371RAirglas Inc · Anchorage, AKN5372PGreene David Trustee · Tyler, TXN5373CJoy Solutions LLC · Wilmington, DEN5373QMallatt Michael N · Galena, KSN5374CPaulson Chris M · Eatonville, WAN5376CDynamic Aerospace Inc · Framingham, MAN5377Miller David P · Granite, ORN5377TAllen James W · Lakewood Ranch, FLN5378RGittlein Paul A · Wasilla, AKN5379QSky Limit Services LLC · Miami, FLN5379TBerry Kevin R · Bowie, TXN5380CCoggins Josh · Bonney Lake, WA
Back to AD 94-05-05 R1