AD 90-04-06 R1
Registered aircraft · 68,377
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-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N897GArcher Flight LLC · Wilmington, DEN897GAPruim Bradley · Dorr, MIN897HParagon Flight Training Co · Fort Myers, FLN897JSMurray James P · Parrish, FLN897JWAmh Properties LLC · Auburn, ALFirst renewal noticeN897MBJts Aircraft LLC · Rock Hill, SCN897RVPorter David T · Martinsburg, WVN897SCPeregrine Howard Partners II Lp · New Orleans, LAN89800Ballesteros Irlena · Glendale, CAN8980RHolmes Aviation Inc · Cannon Falls, MNN8980VSweitz-Air Inc · Stewartstown, PAN8980YTomu Fly LLC · Vero Beach, FLN89811Sky Warrior Flight Training Inc · Pensacola, FLN89812Fremont Aviation Inc · Fremont, NEN89815Pinnacle Aviation Services Inc · Encinitas, CAN8981RBlock Raymond J · Palmer, AKN8981YGrey Enterprises Holdings LLC · Kalispell, MTN8982DNorth Sound Aviation Inc · Sedro Woolley, WAN8982RBoo Steven R · Chisago City, MNN8982VHirsch John K Trustee · Gerald, MON8982YCovington James P · Poplar Grove, ILN8983JStensrud Maynard R · Waseca, MNN8983LSale Reported · Austin, TXSale reportedN8983VMoon Reagan E · Bossier City, LAN8984CBaldwin Alexander L · Saint Charles, MON8984JKlassen Wayne V · New Ulm, MNN89859Hess Garrett J · Fullerton, CAN89863Ruess Richard M · Anchorage, AKN89869Wings Over Texas Holdings LLC · Denton, TXN8986JKleinberg Kenneth A · Saugerties, NYN8986LHenrichs Jason · Pearland, TXN8986RYarbanton John Robert · Muskegon, MIN8986VAirline Transport Professionals Corp Of USA · Wilmington, DEN89877Hillsboro Aero Academy LLC · Hillsboro, ORN89878Corwin Shawn M · Tucson, AZN8987LScholten John E · Marne, MIN8987VPiper Capital Growth Fund LLC · Scottsdale, AZN8987YHanson William D · Soldotna, AKN89881Fulton Gene · Spartanburg, SCN89887Pea-Wayman Flight LLC · Daytona Beach, FLN8988CEastin Toby M · Jefferson City, MON8988JMerkle Hunter T · Mattawa, WAN8988RYoung Andrew J · Eagle River, AKN8988VWahle Daniel C · Missoula, MTN8989JJohnston Family Clinic Inc · Meridian, MSN8989XCascadia Aircraft LLC · Sandpoint, IDN898AMyers D M · Vancouver, WARevoked, canceledN898AMWyatt LLC · Hot Springs, SDN898DANopat LLC · North Charleston, SCN898DKPratt Christopher J · Dallas, TX
Back to AD 90-04-06 R1