AD 95-22-01
Registered aircraft · 5,258
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:95-22-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-22-01')
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:95-22-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-22-01') 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.
N108JNPremier Jets Inc · Hillsboro, ORN108KCV1vr LLC · Wilmington, DEN108RBAerotrust Services Corp Trustee · Wilmington, DEN108RTMassachusetts Institute Technology · Lexington, MAN108VRDraughn Aviation LLC · Salado, TXN109BGAviation Leasing Group Inc · Wilmington, DEN109DCFrog Force One LLC · Texico, NMFirst renewal noticeN109GAFinancial Mistake Air LLC · Uvalda, GAN109JCL&F Aviation LLC · Dallas, TXN10EGJarcav LLC · The Woodlands, TXN10FKing Leasing Corp · San Diego, CAN10FNGh Equipment LLC · Dover, DEN10GGMartinelli Alexander Joseph · Waco, TXN10GJGlobal Jetcare Inc · Brooksville, FLN10KJKtkj Challenger LLC · Houston, TXN10LYAir & Water Research Corp · Wilmington, DEN10MMSarma Aviation LLC · Fort Wayne, INN10NCHayward Enterprises Inc · High Point, NCN10TCGardner Aviation LLC · Hot Springs, ARN10TDPrairie Air LLC · Aberdeen, SDN10TNPacific Rim Management LLC · Downey, CAN10UHUniversity Of Alabama Board Of Trustees · Birmingham, ALN10YUNutrawise Corp · San Clemente, CAN1101AHeritage Aviation Services LLC · Dallas, TXN110CPPruitt Corp · Leesburg, VAN110JDChandler Air LLC · Bossier City, LAFirst renewal noticeN110JWAli Air LLC · Missouri City, TXN110SNAlliance Aviation Group LLC · Wilmington, DEN111AFWings Aloft Inc · Portland, ORN111CCWilmington Trust Co Trustee · Wilmington, DEN111KRLs 464 LLC · Colorado Springs, CON111LJSourek Trail Co Inc · Barberton, OHN111PTpr Aviation LLC · Evergreen, CON111PJG&L Aviation Services LLC · Las Vegas, NVN111RBClear Skies LLC · Allentown, PAN111RZMetropolitan Telecommunications Corp Of De LLC · Holmdel, NJN111SGAir Orlando Helicopters And Leasing · New Smyrna Beach, FLN111WHWhiskey Hotel LLC · Houma, LAN11206United Airlines Inc · Chicago, ILN1124AWillhope Aviation LLC · Mckinney, TXN1125AAviation Trust Company LLC Trustee · Oklahoma City, OKN112EMRegistration Pending · Las Vegas, NVRegistration pendingN112VLBank Of Utah Trustee · Salt Lake City, UTN113SRAdams Aviation Services Inc Trustee · Wilmington, DEN113USUnited Supermarkets LLC · Lubbock, TXN114KNKnc Flights LLC · Beaverton, ORN114KSUSA Up Star Air Charters LLC - S Series B · Greenwood, INN114VRSkyline Holdings LLC · Hailey, IDN115BHBighorn Airways Inc · Sheridan, WYN115EATso Aviation LLC · Conway, AR
Back to AD 95-22-01