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.
N2505YGauges Green LLC · Euless, TXN2506BRunway Champ LLC · Edwardsville, ILN2506KMccann Ryan J · Washington, DCN2506USterling John A · Port Lavaca, TXN2506YTouching Clouds LLC · Bridgeview, ILN25070Brill Bernard M · Pleasant Grove, CAN2507CLagrone Dawnelle E · Longview, TXN2507FMorley Thomas O · Emmett, IDN2507YGap Mountain Development LLC · Jaffrey, NHN2508BMiller David S · Mount Sterling, KYN2508FBailey Joseph H · Port Saint Lucie, FLN2508NSchneider Kalan J · Intl Falls, MNN2508YWarren Jerry L · Medford, ORN25099Waterwings Seaplanes LLC · Hoover, ALN2509LSchufeldt Lawrence H · North Platte, NEN2509USnyder Mari A · Brighton, CON2509VBrown James · Georgetown, MEN2509YAgha-Khan Sikander B · Carolina Shores, NCN250KBodrero Roger Jay · Outlook, WAN250KEThomsen Nickolas J · Bend, ORN250SCMeadors Leland T Jr · Boyd, TXN2511FBradley Cole Mckee · Temple, TXN2511VSutton Aircraft Salvage LLC · Palmer, AKN2511ZHensley Ty G · Lake Wylie, SCN2512BStikeleather Caro Anne · Arlington, VAN2512JHaller David Henry Trustee · Grover Beach, CAN2512KShetter Justin M · Harrisburg, PAN2512UNative Sons Aviation LLC · Lake Placid, FLN2512VNichol Nathan P · Anchorage, AKN2513BKimble Allen J · Plano, TXN2513DPetite Randall L · Lake Tapps, WAN2513FKeller Jeffrey B · Mount Ulla, NCN2513JT3 Flight Time Building LLC · Richmond Hill, GAN2513LDahlberg James C · Ogilvie, MNN2513VMcrobie Roger L · Maryville, TNN2513YWilson Hubert Ernest · Gustavus, AKN2514CPayne Jonathan R · Montgomery, ALN2514DWeindel Victoria E · Anchorage, AKN2514KSmith Jeffrey C · Asheboro, NCN2514LRegistration Pending · Macclenny, FLRegistration pendingN2514UHenson David C · Fort Worth, TXN2514YBargabos Julie A · Peterboro, NYN25159Jeffrey P Mcauley Dmd Inc · Midland City, ALN2515CCorbett Derek B · Durham, NCN2515DCooper Gerald W · Kennewick, WAN2515JStockweather Eric A · Normal, ILN2515KPatton John W · Mancos, CON2515LClear Air Aviation LLC · Talkeetna, AKN2515VBoyd Robert T · Quakertown, PAN2516FBourne Cynthia A · Melbourne, FL
Back to AD 94-05-05 R1