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.
N25271Byrnes Daniel P · Anchorage, AKN2527GRafter H Livestock · Rawlins, WYN2527JHunt Wayne A · Delta Junction, AKN2527LWooten Craig J · Campobello, SCN2527QTwenty Inc · Wilmington, DEN2527SCensair LLC · Santa Fe, NMN2527YSuazo Tito L · Glendale, AZN25284Riverside Flight Center Inc · Tulsa, OKN25286Recreational Enterprises LLC · Sanford, FLN2528JMichael Matthew C · Ames, IAN2528LWings Of Faith · Stevensville, MTN2528RHutchens Robert L II · Mocksville, NCN2528YHock Adam · Ankeny, IAN2529JSale Reported · Geneva, OHSale reportedN2529UCampbell Alto L III · Pike Road, ALN252DLPlac Holdings LLC · Paradise, TXN252ERBeaurayne Holdings LLC · Prairieville, LAN252GSWyoming Seaplanes LLC · Alpine, WYN252HPFino Al Cielo LLC · Jacksonville, FLN252JMMccallister Billy G · Virginia Beach, VAN252KCPatton Steven W · Fayetteville, ARN252MTAero Quest LLC · Olive Branch, MSN252RAReynolds Darryl G · Wills Point, TXN252SLone Peak Air LLC · Gillette, WYN252SBRoberts Christopher E · Anchorage, AKN252WCMosier Paul L · Ventura, CAN25301Southern Arkansas University Technical Branch · Camden, ARN25302Steiner Jason A · Sabetha, KSN2530GRegistered aircraftN2530KInternational Air Services Inc Trustee · Carson City, NVN2530LSholes Lance M · Oregon City, ORN2530RHines David L · Lancaster, CAN2530VAnderson Jeffrey L · Harrisburg, SDN2530YHarbour William T Jr · Mobile, ALN2531JCrowder Jr Thomas E · Whitesburg, GAN2531LAiken Justin M · Arden, NCN2531QRegistered aircraftN25325Sunrise Aviation Inc · Ormond Beach, FLN2532GWilliams Mark E Trustee · Reno, NVN2532JDel Mar College District · Corpus Christi, TXN2532RDelong Erika Dee · Forest Lake, MNN2532SGrant Roderick M · Dillingham, AKN2532UMills Randall J · Monroe, MIN2532YBatie Gregory T · Rogers, ARN2532ZWest Charles A · Independence, ORN25332Ewing John L Jr · Yuma, AZN2533QBusse Alana · Thousand Oaks, CAN2533RAdams Michael B · Scottsdale, AZN2533VHasselvander Brian K · Columbia, MSN2534RRobuck Dale J · Knoxville, IA
Back to AD 97-01-13