AD 90-06-13
Registered aircraft · 1,827
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:90-06-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-13')
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:90-06-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-13') 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.
N812MEBig Blue Sky Aviation Co · Midland, TXN812SHCamp Logistics LLC · Scottsdale, AZN813JDApple Air LLC · Tieton, WAN813RERichmond 135 LLC · Norwalk, CTN813SHN813sh LLC · Omaha, NEN814BRWinston Electric Inc · Lubbock, TXN814SHSilverhawk Aviation Inc · Lincoln, NEN815CMAmerileasing Corp DBA · Cheyenne, WYN816SHSilverhawk Aviation Inc · Lincoln, NEN817EATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN817SHTilt Up Travels LLC · Norfolk, NEN818BFStarlight Aviation LLC · Harvey, LAN818DEMt Gilead Full Gospel International Ministries Inc · North Chesterfield, VAN818RJCamacho Xpress LLC · Miami, FLN818RUWorldwide Alliance Air LLC · Ocala, FLN818SEB&N Transport LLC · Dover, DEN818SHSilverhawk Aviation Inc · Lincoln, NEN819EKMaisaka LLC · Fremont, CAN819KRPrestige Worldwide Flights LLC · Imperial, CAN819SCHb4 LLC · Las Vegas, NVN819SHSilverhawk Aviation Inc · Lincoln, NEN81TFA P A C LLC · Berlin, NJN81TLC S & P Rocky Mountain Inc · Cheyenne, WYN820MCMontana 8083 Leasing Co LLC · Kalispell, MTN823CBThunderbird Equipment LLC · Hillsboro Beach, FLN823PMHernco Gp LLC · Fort Worth, TXN825KASav Aviation LLC · Jacksonville, TXN825UWConcept Jet Services Inc · Gainesville, FLN826ACTwin City Jets LLC · Wilmington, DEN826RTHunter Resources LLC · Bossier City, LAN827DLGa Ventures LLC · Scott, LAN828BGSweet Seasons Aviation LLC · Pharr, TXN829CBN829cb LLC · Amarillo, TXN829TGLulays Aviation LLC · Salem, ORN829TWTwhiskey Aviation LLC · Lawton, OKN82MLJltbm Investments Inc · Park City, UTN82VMAfo Holdings LLC · Sheridan, WYN83Federal Aviation Administration · Oklahoma City, OKN8300GUS Special Operations Command · Tampa, FLN830ECAvfrac Nb LLC · Seguin, TXN830JBCalcutta Air LLC · Dover, DEN830MG303sd LLC · San Jose, CAN831VPAlana 650 Aircraft LLC · Waterford, MIN831WPVagus Group Inc · Wilmington, DEN833JPEpic Aviation Inc · New Smyrna Beach, FLN8344MAerotrust Services Corp Trustee · Wilmington, DEN834DCYoung John A Trustee · Driggs, IDN837EXBank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeN839EXBank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeN83EPRegistered aircraft
Back to AD 90-06-13