AD 2011-23-07
Registered aircraft · 219
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:2011-23-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-23-07')
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:2011-23-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-23-07') 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.
N20BDHarbor Aircraft LLC · Wilmington, DEN20BLKiowa Aircraft Leasing LLC · Colorado Springs, CON211TAG150-223 LLC · Easton, MDN213EPJssi Parts LLC · Chicago, ILN217MSS&S Aviation LLC · Florence, ALN222HKNdw Hawk LLC · Laurel, MSN224GGGator Tracks LLC · Destin, FLN225JDAlliance Aviation Group LLC · Wilmington, DEN22GGoodyear Tire & Rubber Co · Akron, OHN236PSHoffman Corp · Lake Oswego, ORN247PSRed Clay Aviation LLC · Pineville, NCN24GGoodyear Tire & Rubber Co · Akron, OHN250HMPdkaa 250 Hm Partners LLC · Ketchum, IDN251LBAerotrust Services Corp Trustee · Wilmington, DEN278GACoramdeo LLC · Dallas, TXN27KB3kb Investments LLC · Wilmington, DEN280LTMcp Investments LLC · Sugar Land, TXN285GAPfc Holdings LLC · Bloomfield Hills, MIN286JJHoran John J Jr · Dallas, TXN299PSMbv Aviation LLC · Waco, TXN29JWSchussboomer Systems Inc · Anacortes, WAN2BGCalifornia Hotel And Casino · Las Vegas, NVN2GPerformance Aviation LLC · Richmond, VAN2HZHerzog Contracting Corp · Saint Joseph, MON300BJRa2024 LLC · Tomball, TXN30MZWildwood Yonder LLC · San Francisco, CAN311MKSkys The Limit Aviation LLC · Dallas, TXN318JFAibonito Aviation LLC · San Juan, PRN324WKDollar Air LLC · Menlo Park, CAN326KHGator One Air LLC · Destin, FLN32BGBigs Property LLC · Norht Sioux City, SDN330APJ19 Aviation LLC · Austin, TXN330WJWaitt Joan T Trustee · La Jolla, CAN33DYReal Estate And Renovate · Bigfork, MTN357JGRegistered aircraftN357PTBenson Legacy LLC · Fort Wayne, INN358TDYang Chi · Lafayette, CON35PSSpotlight Capital LLC · Flower Mound, TXN35RFNational Aircraft Leasing LLC #2 · Seattle, WAN360AVBsc Enterprises LLC · Tulare, CAN361RRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN365SSStallings Robert W · Frisco, TXN366FBMbl Financial LLC · Highland, UTN384JKTravelconfirm Aerolease Inc · Portland, ORN390KXKnight Air LLC · Phoenix, AZN403SLRegistered aircraftN409BMKsnl Aero LLC · Shawnee, OKN415PRDlh N415pr LLC · Cortland, NYN425JRTb Equico LLC · Beaumont, TXN428CJNo Res LLC · Scottsdale, AZ
Back to AD 2011-23-07