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.
N4163RFlying Javelina Aero-Club · Tucson, AZN4167RZorychta Mary Ann · Clinton, ARN4168RJones Donald T Jr · Barrigada, GUN4169RWollen Mark A · Poway, CAN4170WWilson Troy L · Raton, NMN4172RRedemption Inc · Kodiak, AKN4173RWilliams Paul D · Gunnison, CON4173WGordon Jacques L Dmd · Atlanta, GAN4174RSouth Butte LLC · Cedar City, UTN4174WAndrews Steven J · Warner Robins, GAN4175WBauder Plane LLC · Hatfield, PAN41769Tipton John H III · Chesterfield, MON4179WCavada Arthur H · Jamul, CAN417DCFleet 17 LLC · Pittstown, NJN4181WMission Flight · El Monte, CAN4182RSchmidt Tim A · Holdrege, NEN4182WNovember Four One Eight Two Whiskey LLC · Fulton, MON4184RB&S Air LLC · Palm City, FLN4187RAnkrum Donald Larry · Hemet, CAN4189RFarr Fly LLC · Wilmington, DEN4191WHowell Bo L · New Sharon, IAN4193WTurk Gerald L · Victor, MTN4195WSarvis Thomas · Bullhead City, AZN419LJGowenmleah Jill · Lawrenceburg, TNN419PHTaylor Septic Services LLC · Deltona, FLN419SWSouthern Aircraft Consultancy Inc Trustee · Casper, WYN41ALMclain Aviation LLC · Lyons, GAN4201RCrockett Guy S · Louisville, KYN4203RFier Michael A · Mundelein, ILN4204RVeal Tim S · Kenai, AKN4205RMarking Refrigeration Inc · Omaha, NEN4206RTelevision Signal Distribution Specialists Inc · Canton, OHN4208RPeh Aviation LLC · Morristown, TNN4209RLo-Flyer 235 LLC · Boyle, MSN4210RWalle Neil M · Klamath Falls, ORN4211RDyson Michael · Duxbury, MAN4212RLetkeman Abram · Amarillo, TXN4213RClear Blue Skies Aviation LLC · Warner Robins, GAN4215TBaker Michael D · Berlin, PAN4216RJeffordspaul · Naperville, ILN4219T19t LLC · Columbia, MON4220RFoster Carl G · Tucson, AZN4220TMartin Thomas Arthur · Great Falls, VAN4224RElkins S Investments Inc · Cary, NCN4226RClearview Farms LLC · Magnolia, NCN4228RRegistered aircraftN4228TSmith Jerry Wayne · Monroe City, INN422MCWendt Michael · Tecumseh, NEN4231RKearney Larry Neal · Graham, TXN4233R33 Romeo Inc · Wilmington, DE
Back to AD 74-18-13