AD 94-04-13
Registered aircraft · 274
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:94-04-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:94-04-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:94-04-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:94-04-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.
N9135NAdriaans Cornelus A · Wittmann, AZN9159NBoeing Co · Renton, WAN915PRAvialogia Inc · CancunN9160NBoeing Co · Renton, WAN9177Chaffin Christopher · Flower Mound, TXN917GTCentral Airlines Inc · Leawood, KSN9186NShrike One LLC · Deerfield Beach, FLN922BSCentral Airlines Inc · Leawood, KSN929JMCalhoun Paul M · Larue, TXN9383RSmith Casey B · Springer, OKN9397RRock Douglas A · Bloomington, INN9399RJenkins Patrick · Pleasant View, TNN940USanborn Map Company Inc · Colorado Springs, CON957JACbmw LLC · Wise, VAN95ARPfaff Ben J · Bend, ORN961SCVadnais Kenneth G · Santa Barbara, CAN965ARRubio Brunet Pedro Angel · Mulberry, FLN9680EMulkey Howard Daniel · Spanaway, WAN975AAEmez Holdings LLC · Boca Raton, FLN991BDAfk Corp · Ripon, WIN999DATowner Andrew J Trustee · Leawood, KSN999GBPlane Services LLC · Twin Falls, IDN99LQTab Associates Inc DBA · Port Saint Lucie, FLN9QYAmelia Air LLC · Naples, FL
Back to AD 94-04-13