AD 97-25-11 R1
Registered aircraft · 569
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-25-11-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:97-25-11-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:97-25-11-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:97-25-11-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.
N856JLZjets Aviation LLC · Richmond, TXN856PPWkair4 LLC · Boerne, TXN858CV28039 LLC · North Olmsted, OHN859AGRed Line Air LLC · Danbury, CTN868RBSav Aviation LLC · Jacksonville, TXN86NPIcpf LLC · Solon, OHN872BCBcc Aviation LLC · Dover, DEN877HChallenger 5445 LLC · Allentown, PAN878CCApollo Aviation II LLC · Englewood, CON878EMCore Systems · Poway, CAN880CCIntegrated Management Services LLC · Nashville, TNN880FCFawkescorp LLC · Lewes, DEN881BGEtosha LLC · Weston, FLN883CAAdlakha Aviation LLC · Pflugerville, TXN888DHCanadair 5305 LLC · Dover, DEN888GBRegistered aircraftN888QLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN888YCJamm Leasing II LLC · Park City, UTN889MCPnc Bank Na · Boise, IDN89Federal Aviation Administration · Oklahoma City, OKN895CCK & S Aircraft LLC · Scottsdale, AZN898AKPoppa Air II LLC · Wellesley, MAN90Federal Aviation Administration · Oklahoma City, OKN900BHAis Aviation LLC · Newark, DEN900UCBank Of Utah Trustee · Salt Lake City, UTN902AGT C Management Of Florida Inc · Naples, FLN902BResurrection House For All Nations Inc · Union City, GAN902BWGoodfriend Aviation LLC · Knoxville, TNN903AGPnc Bank Na · Boise, IDN905SARegistered aircraftN907WRIal Corp · Lewes, DEN91Federal Aviation Administration · Oklahoma City, OKN910JRegistered aircraftN9191Registered aircraftN919VEOrlando Plane Partners LLC · Orlando, FLN91HKMueller East Inc · Collierville, TNN91KHRhema Bible Church Inc · Broken Arrow, OKN92Federal Aviation Administration · Oklahoma City, OKN926ECJcpe LLC · Boston, MAN926SSJcpe LLC · Boston, MAN939CC601 Assets LLC · Lighthouse Point, FLN94Federal Aviation Administration · Oklahoma City, OKN945FSFly Fishin C LLC · Austin, TXN949MCWolfpack Aviation LLC · Tysons, VAN94SFTriad Aviation LLC · Tyler, TXN95Federal Aviation Administration · Oklahoma City, OKN954BASentinel Services Group LLC · Brooksville, FLN955TMCharon Services LLC · Sheridan, WYN961TCBank Of Utah Trustee · Salt Lake City, UTN967BGE&B Ride LLC · Greenwich, CT
Back to AD 97-25-11 R1