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.
N605TRTarco Aircraft Funding LLC · Fort Lauderdale, FLN605VVSw Automotive Management Holdings LLC · Highlands Ranch, CON606JLRegistered aircraftN60BSBravo-Fox LLC · Atlanta, GAN610LValiair Lc Trustee · Casper, WYN611ABPollard Spares LLC · Roanoke, TXN611AZPaloma & Joan LLC · Dover, DEN613JRGlobal Aviation Network LLC · Allentown, PAN614PJJem Leasing LLC · Etna, OHN614SGTsg Holdings Company Ga LLC · Atlanta, GAN615BNOnward And Upward Aviation LLC · New York, NYN617BWWhite Aviation Holdings LLC · Boston, MAN618CRLeidos Inc · Reston, VAN618JJJj Challenger 620tm LLC · Wilmington, DEN618RRFat Boy Leasing LLC · Wilmington, DEN61FFPayne Aviation Weslaco LLC · Weslaco, TXN620PJFth Acquisition Corp Vii · Richardson, TXNon-citizen corporation, flight hours not reportedN621DJNorth Point Aviation LLC · San Francisco, CAN622DDanforth LLC · Columbus, OHN622HAHamilton Aviation Inc · Portland, ORN622JDMusashi Jets LLC · Del Valle, TXN624MYWhitehawk Holdings LLC · Tulsa, OKN626KSHoltec Logistics LLC · Camden, NJN627AFAmerican Fidelity Corp · Oklahoma City, OKN628EFSn 5024 Corp · Fort Lauderdale, FLN628GLXxx Ventures LLC · Austin, TXN629HGHantz Air LLC · Southfield, MIN62HAJn Equipment Leasing LLC · Seymour, CTN630ARAar International Financial Services LLC · Wood Dale, ILN633WMCsc Delaware Trust Co Trustee · Wilmington, DEN640GRDodson International Parts Inc · Rantoul, KSN648CR7107 Associates LLC · Wilmington, DEN648SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN64JSCelebration Tv America Inc · Houston, TXN64LELuxury Jet Acquisitions Inc · Newville, ALN650ADAircraft Trust & Financing Corp Trustee · Wilmington, DEN650BSBank Of Utah Trustee · Salt Lake City, UTN650CFTvpx Trust Co LLC Trustee · North Salt Lake, UTN650DWGbhp Associates LLC · Saratoga Springs, NYN650ELBank Of Utah Trustee · Salt Lake City, UTN650FBSierra Nevada Company LLC · Sparks, NVN650GEFlying High Leasing LLC · Atlanta, GAN650GKGekabi Aviation LLC · The Woodlands, TXN650GPOcean Acquisition 3 LLC · Denver, CON650HJLambro Aircraft Management LLC · Hillsboro Beach, FLN650HNTvpx Ars Inc Trustee · North Salt Lake, UTN650JRRegistered aircraftN650LCAgco Corp · Duluth, GAN650LERegistered aircraftN-number assigned (import), not yet registeredN650SKPnc Bank Na · Boise, ID
Back to AD 97-25-11 R1