AD 97-01-13
Registered aircraft · 54,837
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-01-13')
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-01-13')
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-01-13') 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-01-13') 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.
N2397XDow Todd J · Wasilla, AKN2398FHorizon Flying LLC · Wilmington, DEN2398SBowser Earle Stephen · Arcata, CAN2398XPerry Brian J · Stuart, FLN2399FJordan Danny L · Medford, ORN2399GJohansson Ronny · Wasilla, AKN2399YCarlson Carl E · Geneva, NYN239ELDingman Marine LLC · Orlando, FLN239JPTj Air Holdings Inc Trustee · Wilmington, DEN239JRBrykin Leasing Corp · Celina, TXN239SERiley Charles Sweeney · Highlands Ranch, CON239TRosman Patrick R · Creston, WAN239TXCivil Air Patrol Inc · Maxwell Afb, ALN239WMPlane Fun Inc Tr (Trustee) · Snellville, GAN23ATCalifornia In Nice Inc · San Jose, CAN23AZNix Jacob DBA · Johnson, KSN23CCulver Marc D · Anchorage, AKN23CBNb Tweet And Sons · Nome, AKN23CCMadrid Jorge M · Tucson, AZN23CFYr-Aircraft Leasing LLC · Bethel, AKN23DBSky High Farmers LLC · Lakeville, MNN23DHOrtiz Guillermo · Puyallup, WAN23DTAlastrom Aviation LLC · Wilmington, DEN23FOurada Mary E Trustee · Tulsa, OKN23FBHektner Douglas M · Girdwood, AKN23FGState Of California Dept Of Fish & Game · Sacramento, CAN23GDPhoenix Composite Solutions LLC · Oscoda, MIN23GLAtlantic Assets Holding LLC · Dover, DEN23GVCongressional Flying Club · Gaithersburg, MDN23JRHerrera Pedro · Spring Branch, TXN23KBRegistered aircraftN23LHHill Lawrence E · Marion, MTN23LKHernandez Byron Jr · Buffalo, NYN23MZGulfstream Media LLC · Daytona Beach, FLN23PFBagge Tom · Monticello, IAN23RGRogers Ralph R · Winifred, MTN23RHCajun Crimson Air LLC · Hoover, ALN23RLCaljet Inc · Van Nuys, CAN23SFTarhanick Timothy P · Livonia, MIN23XGUsda Forest Service Fepp · Malvern, ARN2400CFloyd William W · Anchorage, AKN2400QGc10 Aero LLC · Birmingham, ALN2400RJenkins Clayton S · Brock, TXN2400YClark Nikita C · Ontario, ORFirst renewal noticeN24012Grubba Gregory T · Anchorage, AKN2401GKidd Alexander P · Nashville, TNN2401JOne-Fifty Inc · Myerstown, PAN2401LDelta Ridge Farms LLC · Oak Grove, LAN2401RSky182 LLC · Eugene, ORN2401YBeauchamp William J · Rigby, ID
Back to AD 97-01-13