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.
N420TCBowling Green Flight Center LLC · Bowling Green, OHN420URcs Services LLC · California, MDN420VHodges Mcneill Jr · Andersonville, GAN420WABlue Yonder Enterprises LLC · Los Altos, CAN420ZBAdaptive Aerospace Corp · Tehachapi, CAFirst renewal noticeN42100Chamberlain Scott Alan · Payson, AZN42101Ross Evan · Lafayette, CON42105H & J LLC · Naturl Br Sta, VAN4210BAkin Andrew D · Senoia, GAN4210JPlamondon Steven J · Lake Leelanau, MIN4210QKoehn Jerome D · Fairview, OKN4210YDm Helicopters LLC · Pekin, NDN4210ZMccarthy Gary W · Chugiak, AKN42111Blanchfield Christine Lizabeth · Devils Lake, NDN42117Sturdivant Marshall J · Ellijay, GAN4211CState Of Colorado Department Of Natural Resources · Denver, COFirst renewal noticeN4211HRn Roofing LLC · Brandon, MSN4211J11j Inc · Fort Lauderdale, FLN4211QJwmp Air Inc · East Moriches, NYN4211XClyde A Russell · Redlands, CAN42120Spiegel Darren J · Chicago, ILN42123Vandeusen Leon W III · Leslie, ARN42124Wright Stephen A · St George, UTN4212542125 LLC · Mercer Island, WAN42126Zrelak Patrick · Apple Valley, CAN4212AEast West Aviation Club · DuffelN4212HG And H Aviation · Louisville, KYN4212SColburn Reno Bryan · Turner, MTN4212TAci Medical Management Inc · San Marcos, CAN42131Massicott David P · Friendswood, TXN42132Witt Lawrence · Solvang, CAN42134Wilmark Anesthesia Pllc · Corpus Christi, TXN4213QFogarty Aviation Inc · Wasilla, AKN4213TMallard Aviation LLC · Manchester, NHN4213XAg Farmacy Applications LLC · Erie, ILN4213YFandrich Edward I · Payson, AZN4213ZFarmer Aviation LLC · Milan, MIN42141Over The Top Aviation Inc · Jonesboro, ARN42148Rizzo Michael R · Yorba Linda, CAN4214HGranger Andrew J · Denver, CON4214MLawler Helicopter Leasing LLC · Rochester, MIN4214QMms Aircraft Leasing LLC · Williamsburg, VAN42150Custom Air Solutions LLC · Broadway, VAN42151Foster Floyd W · Lyon, MSN42154Datil Fly Inc · Saint Augustine, FLN42159Cutruzzula Arthur · Pittsburgh, PAN4215HDavis John N · Port Alsworth, AKN4215SHolliday Bryan E · Flower Mound, TXN4215TBaker Michael D · Berlin, PAN4215YCg Air LLC · Mason City, IA
Back to AD 2007-04-19 R1