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.
N39861Hafley Richard D · Big Spring, TXN39862Shipley Steven D · Masterson, TXN39863Peeples Ryan K · Folkston, GAN39868Horizon Adventures LLC · Alamogordo, NMN3986PWester Lawrence Cale · Star, IDN3986QMfv-N5498q Owners Association Inc · New Church, VAN3986WDelaware Flyers Inc · Fort Wayne, INN3986XFitzwater Randy · Patterson, MON39876Bawden Ronald M · Rough And Ready, CAN39878Beckett Aero LLC · Roy, WAN39879Flippen Danny W · Fort Smith, ARN3987GParkhill Scott · Perrysburg, OHN3987NCascadia Software Inc · Puyallup, WAN3987PElliff Tyler · Windsor, CAN3987WPhipps Robert Sean · Euless, TXN3987XSky West Aviation Inc Trustee · Albuquerque, NMN39880Balloon Promotions Inc · Greenwood, MSN39881Hackler Craig J · Parker, CON39882Crites Samuel V · North Liberty, IAN39885Hummel Mark H · Wyalusing, PAN39889Joplin Samuel K · New Orleans, LAN3988DEvarts Leslie A · Polson, MTN3988MFishback Steve M · Anchorage, AKN3988NSchmeltz Sterling D · Ocala, FLN3988TPalmetto Standard Aviation LLC · Spartanburg, SCN3988WGrant Robert M Trustee · Farmington Hills, MIN3988XMohlenkamp Jami S · Erie, CON39893Owens Gary W · Palo, IAN39896Red Barn Flight LLC · Sauk Rapids, MNN39897Pingston Robert D · Morrice, MIN39899Tolvstad Randy L · Mellette, SDFirst renewal noticeN3989FWfc Aviation Inc · Johnstown, PAN3989GJsh Farms Inc · Hermiston, ORN3989KWeese John G · Fort Worth, TXN3989NOlson Michael J · Grand Island, NYN3989QDms Leasing Co LLC · Las Vegas, NVN3989RTemple Barbara A · Canyon City, ORN3989WHigher Plane Inc · Wilton Manors, FLN3989YSchmitt Rudy · Brookshire, TXN398AGShin Howard I · New York, NYN398AKMach 2 LLC · Fairbanks, AKN398BCNorthwest Back Country Aircraft LLC · Caldwell, IDN398CBone Randall E · Weatherford, TXN398CPCivil Air Patrol · Maxwell Afb, ALN398CVCivil Air Patrol · Maxwell Afb, ALN398DBBenham Aaron J · Sullivan, INN398EPJg'S Mallardaire LLC · Benton, ARN398GBBennett Robert A · Wagener, SCN398HCoco Aircraft Inc · Merritt Island, FLN398KPharris Keth D · Longmont, CO
Back to AD 2007-04-19 R1