AD 94-01-06
Registered aircraft · 4,801
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-01-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:94-01-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:94-01-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:94-01-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.
N107USAmerican Airlines Inc · Fort Worth, TXN1083SGuardian Flight LLC · Lewisville, TXN1088Fmc Corp · Philadelphia, PAN108ADMarquez Padilla Inc · Bonita, CAN108BKKent Aviation LLC · Midland, TXN108FJBuffalo Valley Ventures Of Tn LLC · Cookeville, TNN108PHYoung Family Aviation LLC · Sugar Grove, ILN108RJDixon John W · Aurora, ORN108UWAmerican Airlines Inc · Fort Worth, TXN1095WEaglemed LLC · Wichita, KSN109BGAviation Leasing Group Inc · Wilmington, DEN109MDM B Duncan Inc · Bakersfield, CAN109UWAmerican Airlines Inc · Fort Worth, TXN10CW911 Aviation LLC · Durant, OKN10KJKtkj Challenger LLC · Houston, TXN10MBAircraft Trustee Services Inc Trustee · Dover, DEN10MMSarma Aviation LLC · Fort Wayne, INN10QWBlackhawk 04 LLC · Portland, ORN10TNPacific Rim Management LLC · Downey, CAN10VJVenture Jets LLC · Lititz, PAN10XBmd Leasing LLC · Portland, ORN1101AHeritage Aviation Services LLC · Dallas, TXN1103GMcn-Air LLC · Macon, GAN110CPPruitt Corp · Leesburg, VAN110PMCcp Air LLC · Norwalk, OHN110UWAmerican Airlines Inc · Fort Worth, TXN1110KPeach Air Corporation · Wilmington, DEN1114KRogers John Stuart Trustee · Hughson, CAN1114ZCarefree Air LLC · San Jose, CAN1116RCtb Inc · Milford, INFirst renewal noticeN111CCWilmington Trust Co Trustee · Wilmington, DEN111FJJfm Air LLC · Wilton Manors, FLN111FWAcme Management Co · Fort Worth, TXN111KCSherrmore LLC · Winter Park, FLN111MQBismarck Air Medical LLC · Bismarck, NDN111PJG&L Aviation Services LLC · Las Vegas, NVN111RBClear Skies LLC · Allentown, PAN111REX Aviation Group LLC · Beverly Hills, CAN111RZMetropolitan Telecommunications Corp Of De LLC · Holmdel, NJN111SSFamily Time Machine LLC · Stuart, FLN111USAmerican Airlines Inc · Fort Worth, TXN1125AAviation Trust Company LLC Trustee · Oklahoma City, OKN1126JBbc Air LLC · Macon, GAN112BJDg Group Aviation LLC · Bloomfield Hills, MIN112EDE D Santos & Associates LLC Trustee · Wilmington, DEN112EMRegistration Pending · Las Vegas, NVRegistration pendingN112PSFrontera Flight Holdings Inc · Dover, DEN112USAmerican Airlines Inc · Fort Worth, TXN1130JN1130j LLC · Huntsville, TXN113DJ3d Jets LLC · Orchard Park, NY
Back to AD 94-01-06