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.
N38996Cherokee Kling LLC · Monroe, CTN3899WMauldin Brett · Madison, GAN3900WStuart Deed Pendell · Elkhart, INN3904WEyler Neale · Goddard, KSN3906WRegistered aircraftN3907WParks Craig W · Stephenville, TXN3909WMargolien Brooks · Orange, MAN3912WFrankie Dixon · Cookeville, TNN3914WGiermek Peter T · Olean, NYN3915XKb Aviation LLC · Lewes, DEN3916WSpiritaire Inc · Saint Louis, MON3917WAir Tipton Inc · Tipton, IAN3919WAir First LLC · Kalispell, MTN3921WJohnson Roger D · Fort Meade, FLN3922WSteffey John · Saint Augustine, FLN3924WFrazier Shannon Leo · De Witt, IAN3925WFrench Nathan E · Wilmington, NCN3930WAvionics Holding Group LLC · Salisbury, NCN3933WHall James A III · Lagrange, KYN3934WStudio Jet Inc · Valley Village, CAN3935WAmbrosio Phillip · Saint Louis, MON3936WStahl Michael Ray Jr · Pleasant City, OHN3937WBowen Wesley B · Dothan, ALN3938WAugust Aero LLC · Kalispell, MTN3941XBroshchan Ruslan · Jackson, MSN3942WLarkin Jason · Zeeland, MIN3943WCox Aviation LLC · Debord, KYN3944WCatlin Flying Service LLC · Twisp, WAN3945WSouth Bay Aviation Inc · Torrance, CAN3945XKatoozian Kambiz · Kirkland, WAN3950MScifly LLC · San Diego, CAN3950WQctr Parts LLC · Big Rapids, MIN3951WRiebecing Karl F · Whitefish, MTN39569Jayo LLC · Winston Salem, NCN3957WPorter Casey · Bluffton, SCN39600Inlet Shores Aviation LLC · Ponce Inlet, FLN3960WTaylor Ryan · Lakeland, FLN39613Ferrando James P · San Pedro, CAN39626Drm Air Group Inc · Lewes, DEN39671N39671 Aviation LLC · Wilmington, DEN3968WDiamond C Aviation Llcj · Gentry, ARN3969WFix Edward L · Beavercreek, OHN3971RResnick Quinn A · Lake Park, FLN3971WJma Aero LLC · Reedsville, PAN3972WMills Charles H · Ashburn, VAN39771Ainley Alan · Paragould, ARN3980WJohnson Ralph W · Shelbyville, TNN3981WDream LLC · Middletown, DEN3982WStrassfield Justin · Moyock, NCN3986WDelaware Flyers Inc · Fort Wayne, IN
Back to AD 74-18-13