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.
N1957FSteward Ashtyn L · Weatherford, TXN1957MStewart Alexander E · Medina, WAN1957RReed Gary L · Bethel, OHN1957WDye Roger C · Pomeroy, WAN1957XDrummond Michael S · Burlington, NCN19582Olson Ben A · Gig Harbor, WAN19587Steward Matthew C A · Broken Arrow, OKN19588Kenner David · Maddock, NDN19589Eaton William I Jr · Seabrook, NHN1958BSale Reported · Champaign, ILSale reportedN1958XOrth Matthew B · Marion, KSN1958YGarner Zachary R Trustee · Anchorage, AKN1959Smith Robert P · Lago Vista, TXN19590Koskan John M · Wood, SDN19592Aviation Trust Co LLC Trustee · Oklahoma City, OKN19594Jeter Ray E · Spring Hill, FLN19597Estrada Katrina · Helotes, TXN1959CTisdale Anthony · Fallon, NVN1959ERedsun Oren D · Fairfield, CAN1959XLyon Mark S · Layton, UTN195GSFairfield Eugene D · Wiscasset, MEN19600Corona Police Aero Squadron Inc · Calimesa, CAN19601Pnl Aviation LLC · Brunswick, MEN19602Lucas Mitchell H · Jackson, GAN19603Stanly Business Consultants LLC · Albemarle, NCN19606Stettner George J · Spring Hill, FLN19609Johnson Erik S · Navarre, FLN1960FCornerstone Financial Enterprises LLC · Mesquite, NVN1960MJereb Robert M · Rohnert Park, CAN1960XPena Fermina · Brentwood, NYN19610Berg John R · San Pedro, CAN19614Clark David R · Terrebonne, ORN19618Seymour David E · Evergreen, CON1961BGoose Aviation LLC · Cumberland, WIN1961DMulligan Kevin S · Port Alexander, AKN1961FRemove B4 Flight LLC · Joplin, MON1961MSwindle Malorie J · Birmingham, ALN1961UMccarthy Trevor William · Addison, TXN19620Schmidt Jeffrey A · Othello, WAFirst renewal noticeN19622Baker Timothy G · Curtis, NEN19624Jlinn Aviation Inc · Quinlan, TXN19625Novak Daniel F · Palmyra, WIN19629Anvab Inc DBA · Concord, NHN1962DTowery Daniel T III · Dover, DEN19630Brignoni Ruben Mercado · Isabela, PRN1963GOlson William A · Florence, ORN1963QJohnson Clinton B · Alpharetta, GAN1963VFerguson George W · Vero Beach, FLN1963ZMarker Nathan E · Amherst, OHN19640George Gary D · Humble, TX
Back to AD 97-01-13