AD 94-05-05 R1
Registered aircraft · 26,225
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-05-05-R1')
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-05-05-R1')
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-05-05-R1') 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-05-05-R1') 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.
N10693Full Stop Aviation LLC · Union City, TNN106FBZimmerman Frederick J · Boulder City, NVN106WL3jc LLC · Phoenix, AZN1070HGeary Charles L · Wasilla, AKN1071HBeck Douglas J · Bloomington, MNN1072HBeckman Thomas J · Pocahontas, ARN10732Hale Sidney B · Bonham, TXN10737Shelley Matthew A · Cleveland, NCN10738Lindsay Tyler R · Kimberly, IDN1073YGoedicke Walter H Jr · Bay Head, NJN10741Rice Zachary N · Los Angeles, CAN10742Lewis Thomas R · Aransas Pass, TXN10747Smith James E · Port Charlotte, FLN10748Jensen David · Bronte, TXN10749Atg Capital Management LLC · New York, NYN10750Pomeroy Andrew B · North Berwick, MEN10752Planesmen Aviation LLC · Grant, NEN10754Morris Adam R · Stuttgart, ARN10758Round Engine Aero · Nashville, MIN1075HBartholomew Dana C · Madison, WIN10762Blaisdell Leo F · Kalkaska, MIN10763Cromley Orvis H · Lewisburg, PAN10766Aurora 17 Holdings LLC · Aurora, ORN10769Waddingham William B · Rancho Cucamonga, CAN10773Cole Clayton R · Cottonwood, CAN10774Crawford Carolyn Marina · Kenai, AKN10777Scott Randolph J DBA · New Orleans, LAN1077HHadley Everett F · Dayville, CTN10784Woods James D · Carthage, TXN10785Burton Robert E Jr · Vancouver, WAN1078KClairday Preston H · Melbourne, ARN10793Jarvis Laura A · Cornwall, VTN107PSLadies In Aviation LLC · Mocksville, NCN107RRRiter Bruce D · Los Altos, CAN107ZCHemphill Holdings LLC · Hemphill, TXN10808Carter Curtiss D · Orono, MEN10815Oklahoma Flight Academy LLC · Owasso, OKN1081WPeck Alan W · Chattanooga, TNN10820Wojteczko Jason A · Derby, KSN10829Brekhus Clifford G Trustee · Minot, NDN10830Fundamentals Aircraft Leasing LLC · Erie, PAN10832Hardin Tim A · Monroe, LAN10836Ahmed Rehan J · Little Elm, TXN10838Hadley Paul T · Yelm, WAN10839Eagle Equity Inc · Valparaiso, INN1083HHead Wesley J · Homer, AKN10843Mathers Steven A · Post Falls, IDN10844Cohan John K · Marina, CAN10846Drewsaero LLC · Nacogdoches, TXN10847Lowe Luz E · Arlington, TX
Back to AD 94-05-05 R1