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.
N4238RMarianas Air Transfer Inc · Saipan, MPN4239RWilson John T · Castalian Springs, TNN423JWSkeens Gregory Jr · Encinitas, CAN4241RFsi Aviation LLC · San Antonio, TXN4250RNewsome George W III · Palmyra, NYN4254RStar Marianas Air Inc · Saipan, MPN4259RThorn Robert L · Clovis, NMN425CHKeeton Farms LLC · Monticello, KYN4260RColin Irons Diving And Pool Service · Crawfordville, FLN4262RKirkpatrick Alan E · Oklahoma City, OKN4266RBig Guy Enterprise Transportation LLC · Portland, ORN4270RKreiser Foster E Jr · Middletown, PAN4270TAllen Aero LLC · Saint Cloud, FLN4272RModic David J · Escondido, CAN4277RFoxtrot Golf LLC · Kalispell, MTN4279RCummins Dan D · Blencoe, IAN4280RRupp Amanda E · Osteen, FLN4289RShaughnessy Paul V Jr · Norwood, MAN4290RLadet David E · Lavonia, GAN4292RSky West Aviation Inc Trustee · Albuquerque, NMN4293RLaws Chris · Mckenzie, TNN4296RJohnstone Colin · Enterprise, ALN4297R4297 Romeo Aviation LLC · Owasso, OKN4298RAv79 Aviation LLC · Dover, OHN4299RRimlinger Timothy Trustee · Audubon, PAN429SFLewis Jason M · Camden, ARN42CJNewman Robert A · Discovery Bay, CAN42CXSilver Hawks Ltd · Columbus, OHN43070Wkb Aviation LLC · Walnut Creek, CAN4307TMartin Russell L · Atascadero, CAN43108Hunter Aviation Inc · Albany, GAN4315TCommunity Health Alliance · Fairfield, OHN43170Craig John IV · Lilburn, GAN43276Wilson Steven D Trustee · Mount Pleasant, IAN4332TOld Fart Aviation LLC · Carroll, OHN4334TMacphail Douglas J · East Longmeadow, MAN4339TJpm Investment Group LLC · Pascoag, RIN433STCirrus Chaser LLC · Thomasville, GAN43451Redwood Air LLC · Roanoke, TXN43527Ball Fred E · College Place, WAN43618Ferrandi Pierre · Phoenix, AZN4362TYost Jim · Flora, INN4365TStruckmeyer Ingo H · Normandy, TNN43664Johnston William R · Jackson, NCN4370FRmr Inc · Exeter, CAN4371TBlevins John · Huntsville, ALN4371XBaptist Mid Missions · Cleveland, OHN43796Tpa LLC · Augusta, GAN4384XPennell Bobby · Hobbs, NMN4394TLinden'S Aviation LLC · Lagrange, OH
Back to AD 74-18-13