AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N3380RHunter Robert R · Springville, PAN3380XGretencord Howard F Trustee · Kansas City, MON3380YLaramie Flying Club Inc · Laramie, WYN3380ZSchwend Brian · Forsyth, MTN33815Hyde Leasing LLC · Water Valley, MSN33816Hettinger John E · Sterling, CON3381FAttema Symon Nmi · Norco, CAN3381UCenter Of Excellence Corp · Cheyenne, WYN3381XBagwell Trevor T · Valencia, CAN3382DBond Jeffrey A · Las Cruces, NMN3382RWatch Out LLC · Scottsdale, AZN3382SNorthern Sonic Alaska Inc · Fairbanks, AKN3382WMoffatt Jeffrey Charles · Morgan Hill, CAN3382YJenkinson John III · Lakin, KSN33831D&K Sales Inc · Canton, GAN33836Patton Daniel E · Thornton, PAN3383DStyer Michael J · Amarillo, TXN3383RDeatley Derek · Mohave Valley, AZN3383SStewart Bryan · Carson City, NVN3383TBerkstresser John A · Ellijay, GAN3383WFour Dudes Flying LLC · Cabot, ARN3383XHiger Matthew Ward · Las Vegas, NVN3383YJohnson Brian B · Monroe, LAN3383ZMcghee Johnny A · Louisburg, NCN33847Registered aircraftN33848Crymes Robert S · Woodbridge, VAN33849Sanzaro Aero LLC · Bunnell, FLN3384R3384 Romeo LLC · Jackson, MON3384XWendt Wesley A · Leavenworth, KSN3384YOliveira John S · Plant City, FLN3384ZJones Robert D Jr · Chugiak, AKN33850Jbm Ventures Inc · Apollo Beach, FLN3385LTonka Seaplanes LLC · Minnetonka, MNN3385RHill David A Jr · Needham, MAN3385XKelly Paul M · Granite Bay, CAN3385YNoah Aviation LLC · Ellabelle, GAN33863N318bm LLC · Monroe, LAN33864Hirsch Bernard David · Carmel, INN338672 F LLC · Valentine, NEN3386ED Gordon Aviation Inc · La Jolla, CAN3386FN3386f Flying Club Inc · Pickerington, OHN3386WTranswestern Air Service Inc · Golden, CON3387FChristensen Robert F · Gillette, WYN3387RSkypartners LLC · Buhler, KSN3387TWarner Stephen DBA · Pleasantville, PAN3387USkynick Enterprises Inc · Tarzana, CAN3387YBhogal Balvinder S · Biloxi, MSN3387ZBlake Clark D · Belle Fourche, SDN3388PMorrison Maria · Port Townsend, WAN3388RFamily Air Fares LLC · Wilmington, DE
Back to AD 2007-04-19 R1