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.
N8908NH & H Aviation LLC · Provo, UTN8909NKrull Doug · Hendersonville, TNN890DFMarine Investments Llp · Morganton, NCN8910KCoulter Ts LLC · Midway, UTN8910NRam Aeronautics LLC · Wichita Falls, TXN8914NTreetop Flyers LLC · Vashon, WAN8916NBundy Richard · Little Egg Harbor, NJN8918NStratton Erin B · Baton Rouge, LAN8922NKew Malcolm M · Hercules, CAN8923NMiller Jarred J · Burton, OHN8924NRobinson Andrew · Auburn, CAN8925NMackay James R · Corunna, MIN8927NHoffman Gary D · Spencer, NEFirst renewal noticeN8937NSchewe William M · Greenville, ILFirst renewal noticeN8939NOakley William J · Kildeer, ILN8942NMinnema Samuel S · Fairbanks, AKN8943NChase-Six LLC · Orange Park, FLN8947NGarfield Air LLC · Burwell, NEN8948NC6 Flying LLC · North Logan, UTN8950NWatson Richard D · Plant City, FLN8952CZell Zulu LLC · Greensboro, NCN8952NCircle K Supply Chain Solutions LLC · Knoxville, TNN8954NSabbagh Mouin F · Missouri City, TXN8955NRichart Nicholas J · Clever, MON8957NN8957n Inc · Wilmington, DEFirst renewal noticeN8960NSkyriders Inc · Pocatello, IDN8962NGallen Peter · Wilmington, DEN8963NBaker Daniel T · Jackson, OHN8966NCherokee Six LLC · Minburn, IAN8969NMatanane Roke C · Barrigada, GUN8979NPeeling Clyde R · Allenwood, PAN8981AAmerican Aircraft Sales LLC · Lincolnshire, ILN8984NBlair Gary B · Salado, TXN8986NBay Air Inc · Dillingham, AKN8988NCicero Flying Club LLC · Indianapolis, INN898CPThomas Robert M Jr · Kissimmee, FLN8992NBenedict Kevin M · Lakeland, FLN8996NBickford Shawn A · Auburn, CAN8998NHangar Cc5 LLC · Gainesville, GAN899JBInvestors Trust Co Trustee · Duncan, OKN89BSHalbert Consulting LLC · Enoree, SCN8PT10wg LLC · Newman Lake, WAN9000MSaipan Transportation Management Solutions Inc · Saipan, MPN900CLThomasson Glen P · Clinton, NCN901BLMaritime Helicopters Inc · Homer, AKN90289Kuhlman Construction Company · Colesburg, IAN9028KVan Duzer Peter John · Greenville, WIN903HWJackson Construction Services LLC · Wichita Falls, TXN9089K&M Land Surveying Inc · Lincoln, NEN908DKNeilson Frank · Orlando, FL
Back to AD 74-18-13