AD 74-18-13
Registered aircraft · 1,642
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:74-18-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:74-18-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:74-18-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:74-18-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.
N3671WOdean Steve · Palmer, AKN3673MBeacon Park Pointe LLC · Orlando, FLN3675WWilson Ag Consulting LLC · Boise, IDN3677WGriffith Chad Wayne · Crosby, TXN3678MCometair LLC · Greensboro, NCN3678WDiamond B Farm Inc · Gamaliel, KYFirst renewal noticeN3680WBeachy Titus E · Altamont, TNN3683WHaure Pierre II · Rayne, LAN3686WLadet William D · Las Vegas, NVN3687WBluewater Marine Group Inc · Wilmington, DEN3692WMckimson Lance D · Wasilla, AKN3696WSantos Marc · Lincoln, RIN3703WGill James A · Gaithersburg, MDN370WCInternational Air Services Inc Trustee · Carson City, NVN3710WPdr LLC · Royal Palm Beach, FLFirst renewal noticeN3713WRvn Trucking LLC · Tilden, NEN3716WRobb Air LLC · Escalon, CAN3721WFiumerodo Flavio · Tarzana, CAN3725WKosko Stanley G · Seattle, WAN3727WTriple C Air LLC · Madison, GAN3728WGalactic Air LLC · Ringoes, NJN3729WColeman James C III · Saint Augustine, FLN3730WEye South Equipment LLC · Greenwood, MSN3736WLarsen Christopher R · West Melbourne, FLN3737MMathur Arvind Kishore · Hemet, CAN3737WVoss James S · Soldotna, AKN3738WNewton Machine Co Inc · Charlotte, NCN3739WPacific Gold Aviation Association · Roseville, CAN3742WRibas Daniel · Atascadero, CAN3746WN3746w Corp · Wilmington, DEN37491Tuskegee Airmen National Historical Museum Inc · Detroit, MIN3750WNichols John L · Parksville, NYN3751WEthridge Lee C · Mount Pleasant, TXN3754WHam Aviation LLC · Maysville, KYN3755WMs Air LLC · Hickory, NCN3756WAranda Jarrod A · Vancouver, WAN3757WSowden Nathan S · Annapolis, MDN3760WTonini Ryan · Huntsville, ALN3763WDaise Nicklaus J · West Chester, PAN3765WMazzochi James A · Hilton Head Island, SCN3772WBlue Horizons Flying Club Inc · Perrysburg, OHN3779WAirmotive Service LLC · Brigham City, UTN3780WRaines Marshall A Jr · Whiteside, TNN3784WBas Part Sales LLC · Greeley, CON3786WDavis William K · Fredericksburg, VAN3790WScudder Adam J · Orlando, FLN3791WCherokee Trail Aviation LLC · Tontitown, ARN3792WFrazer Thomas · Warren, ARN3793WBas Part Sales LLC · Greeley, CON3795WWendt Aaron · Temecula, CA
Back to AD 74-18-13