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.
N3547FEastern Kentucky University · Richmond, KYN3547KAlexander Robert D · Ardmore, OKN3547MBernstein Matthew D · North Charleston, SCN3547RL & R Flyers LLC · Bradenton, FLN3547UPanhandle Aviation LLC · Thatcher, AZN3547WNatwick Joel T · Port Alsworth, AKN3547YS & W Aviation LLC · Saint Peters, MON35486Metz Air LLC · Little Rock, ARN35488Collins Mason G · Gillette, WYN3548PHalley Dan R · Avery, TXN3548TAlsworth Glen R Jr · Port Alsworth, AKN3548VT-28 LLC · Salem, ORN35498Ray Arthur G · Springdale, ARN3549UKimble Bryant Shane · Hinton, OKN3549YTimuuu Inc · Alden, NYN354ALErlandsen Alan · Bremerton, WAN354BCChamberlain Donald H · Ooltewah, TNN354BGBowling Green Flight Center LLC · Bowling Green, OHN354BWCarpenter Richard A · Hermiston, ORN354CWhite River Resort Inc · Lakeview, ARN354CMMandes George J · Homer, AKN354CPCivil Air Patrol · Montgomery, ALN354CTCoast Flight Training And Management Inc · San Diego, CAN354DAir Repair Inc · Deadwood, SDN354DGGaines Lawrence C · Stockton, CAN354DJN354dj LLC · Gulfport, MSN354DPShaffer John · Virginia Beach, VAN354DRRadwanski D · Westmont, ILN354DZDachnowicz Peter A · Avon, CTN354FBCleared Direct LLC · Portland, ORN354GGUis Aviation Services Inc · Pleasant Grove, UTN354JMountain V-Tail LLC · Denver, CON354JHArrow Group 5 LLC · Lake Saint Louis, MON354KPTri County Flying Club Llp · Estelline, SDN354LCDelos Anesthesia Services Pc · Barstow, CAN354MMission Aviation LLC · Billings, MTN354MAAir Shares LLC · Casper, WYN354MHMission Helicopters LLC · San Diego, CAN354MKNorth Star Aviation Inc · Mankato, MNN354MSSutherland Gary M · Tucson, AZN354PCLund Vern E · Madera, CAN354PFBillen Jerome · Hodges, SCN354STelfer William D · Perkasie, PAN354TAChristiansen Aviation LLC · Wilmington, DEN354TFEmery Scott J · Randle, WAN354XBeaver Creek Aviation LLC · Clinton, OKN35501Wallis Aircraft Inc · Clifford Township, PAN3550FYoung Tom · Alton, MON3550LBatte Bennie Wayne · Forest, MSN3550PYates Darren L · Collinsville, OK
Back to AD 2007-04-19 R1