AD 94-05-05 R1
Registered aircraft · 26,230
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.
N8688SKubik Darrel J · Boise, IDN8688USabol Andrew R · Waterville, NYN8689BTeynor Jason J · Ontario, WIN868DGGualandri Daniel J · North Port, FLN868NTLibby Douglas J · Lake City, FLN8690SSandy River Flying Club · Phillips, MEN8691BHeller Teena · Granbury, TXN8691GWings Over Texas Holdings LLC · Denton, TXN8691SBonner John A III · Ocala, FLN8692BCogan Walter J Jr · Shelter Island, NYN8692SRobinson Deon D · Mesquite, TXN8693UCone Randall D · Salida, CON8694BMiller Jason M · Eaton, OHN8695JN8695j LLC · Buckeye, AZN86961Sale Reported · Grove, OKSale reportedN86962Southern Aircraft Consultancy Inc Trustee · Casper, WYN8696DDupuis Raymond F Jr · Pelham, NHN8697BHillis Gary D · Brookland, ARN8697DHigher Ground Aviation LLC · Ely, MNN8697GAeronautical Technical Service Inc · Collierville, TNN8698GPriddle Kody W · Norfolk, VAN8698JWaddey Caleb M · Cottage Grove, TNN86991Gregory Vernon L · Swansea, SCN86997Corry Thomas F · Rockport, TXN8699GFayette Aviation Inc · Lemont Furnace, PAN869ABHoover Travis · Mountain View, OKN869KERogan Thomas R · Munster, INN86ALCollum Aviation Inc · Milton, FLN86EZRutan Aircraft Flying Experience · Waller, TXN86FHMckinney Eric S · Hamersville, OHN86JFElliott Ronald H · Alexandria, LAN86KWKellett Kenneth W · Auburndale, FLN86LCZiroli Nicholas A · Lake Grove, NYN86WAWyatt David M · Kennewick, WAN8700BWall Bernardo · Seminole, TXN87018Hier Richard · Lambert, MTN8701SRoth David A · Milford, NEN8702BHill Thomas Gerald · Port Tobacco, MDN8702GHaney James H · Brooksville, FLN8703UNea Construction LLC · Jonesboro, ARN87040Burr Walter E · Tecumseh, MIN87055Beste Robert K · Sauk Centre, MNN8705BCarney David M · Mc Allister, MTN8705GHammond Douglas C · Des Moines, IAN8706BCox Robert D · Caldwell, IDN8706SN8706s LLC · Lake Orion, MIN8707BEmblom Donald B · Hackensack, MNN87086Bernard Kate L · Neenah, WIN8708SHall Tyler D · Citrus Heights, CAN8708UDewey William H Trustee · Eugene, OR
Back to AD 94-05-05 R1