AD 97-06-06
Registered aircraft · 2,038
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:97-06-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-06-06')
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:97-06-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-06-06') 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.
N130SFSuburban Air Freight Inc · Omaha, NEN131BLLta Group Holdings LLC · Amarillo, TXN131GPUas Transervices Inc · Boca Raton, FLN131SFSuburban Air Freight Inc · Omaha, NEN131SJGravitas Aviation LLC · Dallas, TXN131SPKauffman Land & Development LLC · Denver, CON132HSCentral Virginia Aviation Inc · Petersburg, VAN132KCAlpine Aviation Inc · Provo, UTN132NFlying Cowboys LLC · Merced, CAN133BAAlpine Aviation Inc · Provo, UTN133GAJab Aire LLC · Wilmington, DEN135AAKentucky King Air LLC · Hazard, KYN136PAX-Press Charter Service Inc · Longview, TXN137BABemidji Aviation Services Inc · Bemidji, MNN139JBQuay Ventures LLC · Alto, TXN139RRRyan Renae L Trustee · Wichita, KSN139SCNew Ulm C90 LLC · Marshall, MNN13FPSafeco Leasing LLC · Port Alsworth, AKN13GZGuardian Flight LLC · South Jordan, UTN140HAxis Transportation Services LLC · Sacramento, CAN140RLN140rl LLC · Kalispell, MTN142EBFly Me LLC · Mc Gregor, TXN143DEAac 585 LLC · Kennesaw, GAN143FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN143TAJrr Motor Sales LLC · Campbellsville, KYN145AFDale Aviation Inc · Rapid City, SDN146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXN147LJGuardian Flight LLC · Lewisville, TXN148SKBering Air Inc · Nome, AKN149SFAlpine Aviation Inc · Provo, UTN14HHDelaware Professional Aviation LLC · Dalton, GAN14MVAlpine Aviation Inc · Provo, UTN14NGFirst Avenue Management LLC · Savannah, GAN14NMDriscoll Health Care Services · Corpus Christi, TXN14SBMountain Air Aviation LLC · Jonesville, VAN14VDouble D International LLC · Miami, FLN150CNKing Air Investments LLC · Ferriday, LAN150GWRocinante Air LLC · Cincinnati, OHN150KJAlpine Aviation Inc · Provo, UTN150RLTigress Air III LLC · California, MDN150TWCentral Virginia Aviation Inc · North Dinwiddie, VAN150VECarnes 150ve LLC · Wichita Falls, TXN150YDSfh Inc DBA · Fargo, NDN151ELCarolina Turbine Sales Inc · Raleigh, NCN151WTKo Aviation LLC · Wilmington, DEN152WLHeart One LLC · Little Rock, ARN152WWNardi Greg · Missoula, MTN153GAAlpine Aviation Inc · Provo, UTN153GLAlpine Aviation Inc · Provo, UTN1544VGuardian Flight LLC · Lewisville, TX
Back to AD 97-06-06