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.
N2504RJht Aviation LLC · Longview, TXN25053Southwinds Export Inc · Kissimmee, FLNon-citizen corporation, flight hours not reportedN25057Nino Jose · Kenilworth, NJN2505LCannon Jason P · La Verne, CAN2505YGauges Green LLC · Euless, TXN2506Cessna N2506 LLC · Doral, FLN2506QJohnson Jason D · Doniphan, MON2506SByers Roger G · Lake Elmo, MNN2506USterling John A · Port Lavaca, TXN2506YTouching Clouds LLC · Bridgeview, ILN2507GBanks Gary M Jr Trustee · Scituate, MAN2507JDarter Lloyd R · Mountain Grove, MON2507RKandle Sherry A · Boise, IDN2507YGap Mountain Development LLC · Jaffrey, NHN2508GBig Well Flying Club Inc · Kinsley, KSN2508RBrodt Gregory L · Chetek, WIN2508YWarren Jerry L · Medford, ORN2509KHolcomb John R · Siloam Springs, ARN2509LSchufeldt Lawrence H · North Platte, NEN2509USnyder Mari A · Brighton, CON2509YAgha-Khan Sikander B · Carolina Shores, NCN250CW250 Charlie Whiskey LLC · Topeka, KSN250FBishop Thomas W · Decatur, TXN250GCCarroll James E Trustee · Newington, NHN250LMenefee Scott A · Los Banos, CAN250RAReynolds Darryl G · Wills Point, TXFirst renewal noticeN2511798x LLC · Caddo Mills, TXN2511DDfs2024 LLC · Edwards, CON2511LDmcflight LLC · Boynton Beach, FLN2511RDickey Mark D · Pendleton, ORN2512GSutton Aircraft Salvage LLC · Palmer, AKN2512JHaller David Henry Trustee · Grover Beach, CAN2512QPeacock Jeffery D · Cleburne, TXN2512SCorsentino Joseph · Temple, TXRegistration revokedN2512UNative Sons Aviation LLC · Lake Placid, FLN2513GSedlickas Mark A · Graham, WAN2513JT3 Flight Time Building LLC · Richmond Hill, GAN2513KCarlson Thomas G · Anchorage, AKN2513LDahlberg James C · Ogilvie, MNN2513YWilson Hubert Ernest · Gustavus, AKN2514LRegistration Pending · Macclenny, FLRegistration pendingN2514RRichmond Patrick A · Glenmora, LAN2514UHenson David C · Fort Worth, TXN2514YBargabos Julie A · Peterboro, NYN2515JStockweather Eric A · Normal, ILN2515LClear Air Aviation LLC · Talkeetna, AKN2516LFlores E Alex · Missouri City, TXN2516ULofton Johnathan V · Springer, OKN2516VGreat Adventure Sailing Vessell LLC · Greer, SCN2516YSchutjer Dennis · Clear Lake, IA
Back to AD 97-01-13