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.
N3318ERodriguez Jose R · Los Angeles, CAN3318FIsland Aero LLC · Tavernier, FLN3318RPetersen Family 1999 LLC · Anchorage, AKN3318TPipeair LLC · Vancouver, WAN3318VArledge Roone Jr · Lakewood Ranch, FLN33195Heathco Merle S · Scappoose, ORN33196One Niner Six Aviation LLC · Anchorage, AKN3319JWelch Cooper · Lee, FLN331DFDc-3 Pro Services LLC · Hailey, IDN331DTTolkach Dennis G · Dunlevy, PAN331JCCsp Aviation Holdings LLC · Dallas, TXN331JTJuliet Tango Flying Services LLC · Walnut Creek, CAN331KWHeritage Academy Inc · Monterey, TNN331LCEblc Aviation LLC · Hollywood, FLN331LSTechnical Education Services Inc · Virginia Beach, VAN331RFRandigo LLC · Wilmington, DEN331SPReinfeldt Phillip R · Burnsville, MNN331TCOn Trend Homes LLC · Columbia, MON3320DPara Tactics LLC · Shelton, WAN3320FPoock Jerry D · Spencer, IAN3320JPollman Justin A · Sherwood, NDN33212Burlingame Lloyd · Fort Atkinson, WIN33216Avarts LLC · New Castle, DEN3321DWood Steveno · Morgan, UTN3321FOwl Aviation LLC · Kingsport, TNN3321JFulton Ricky L · Alex, OKN3321RGray Kerry L · Granbury, TXN3321TWilks Donald Leon · Flat Rock, ALN3321VRegistered aircraftN33220Advanced Analytical Inc · Newbury Park, CAN3322DObrien Aviation LLC · Moreno Valley, CAN3322FCrystalline Entity · Los Angeles, CAN3322UPrecision Design Inc · Wilimington, DEN3322YFostair Inc · Ovid, NYN33230Alaska Air Service LLC · Brookings, ORN3323DPrince Christopher E · Anchorage, AKN3323FFly The Dream LLC · Sun Prairie, WIN3323JRichards Amy L · Union City, INN3323RD&J Air Adventures Inc · Koloa, HIN3323TDeese James K Jr · Charlotte, NCN3323YMiellerie LLC · Bridgeport, TXN33247R House Leasing LLC · Stormville, NYN33248Wilson Harvey Lee · Gadsden, ALN3324UHaer Welton · Craig, MON3324YVoge Michael · Chino Hills, CAN3325RDresick Farms Inc · Huron, CAN3325UWeber Donald E · Saint David, AZN3326FRegistered aircraftN3326RAnderson Patrick Alan · Ripley, WVN3326TGallman Doug M · Port Orange, FL
Back to AD 97-01-13