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.
N17PFFisher Paul A · Dayton, OHN17RBN17rb LLC · Fredericksburg, PAN17SYSeven Sierra Yankee LLC · Monroeville, PAN17TBOwen Bertha C · Port Saint Lucie, FLN17WYPeters Justin B · Mount Vernon, OHN17ZSContinental Title Trust Co Trustee · Wichita, KSN1800Wilkinson Jennive · Midwest City, OKN18004Hause James H · Negley, OHN18006Lockhart Curtis M · Bay Village, OHN18015Little Bird 150 LLC · Lake Tapps, WAN1801CRollins Michael Clayton · Pine River, MNN18020N18020 LLC · Chandler, AZN18021Tilden Jeffrey D · Columbus, INN18023Remain In The Pattern LLC · Meridian, IDN18025Evans II Rodney D · Saint Albans, WVN1802BRegistered aircraftN1802KTrofimoff Alexander V · Overland Park, KSN18032Old School Aircraft LLC · Jackson, TNN18033Barkley John · Austin, TXN1803BBorchers Jonathan M · Independence, ORN1803CWallner David A · Adell, WIN1803VAnderson Michael J · Carmichael, CAN1803YOfficial Stripes LLC · New Braunfels, TXN18042Carey Daniel F · Rockville Centre, NYN18046Beavers David A · Strasburg, CON1804BLyman John W · Orrs Island, MEN1804YSnader Douglas E · West Linn, ORN18050Jarrell Loyd F · Whitesburg, TNN18052Sky Views LLC · Mount Crawford, VAN18057Palmer Jedidiah J · Lewiston, IDN1805CCampbell Stacy D · Buena Vista, CON1805KJohnson Lawrence F · Anchorage, AKN1805NThompson Randy L · Anderson, CAN18061Foster Rodney D · Quanah, TXN18067Get Out Aviation LLC · Palmer, AKN18069Olandese Donald J · Newalla, OKN1806KWells Charles Richard · Hayden, IDN1806VBrown Christopher · Mancelona, MIN1806YMadcity Aviation LLC · Madisonville, KYN18071Rock River Aviation · Watertown, WIN18076Angelos Mark A · Concord, CAN1807CMorriss Elvin A · Springdale, ARN1807ELorobsco LLC · Cavour, SDFirst renewal noticeN1807VBushre David N · Janesville, WIN18081Eyes Above LLC · Hampton Falls, NHN18088Durin Steven C · Steward, ILN1808VReller Bernard D · Gainesville, FLN1808YHardy Russell L · Rimrock, AZN180EFPoe Rick M · Mojave, CAN180EHMccall Edmund B · Portland, OR
Back to AD 94-05-05 R1