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.
N53055Echo Lake Air LLC · Soldotna, AKN53057Endsley Gregory C · Sterling, AKN53059Smith Sidney R Trustee · Rllng Hls Est, CAN5305ARathbun Daniel F · Odessa, TXN5305BHamlin Curtis G · North Pole, AKN5305KJ M F And Associates Inc · Alexandria, VAN5305LStearns Simon K · Edwardsville, ILN5305NBennett Brian · Horseheads, NYN5305PMetzler Kevin W · Rosamond, CAN5305VAmerican Academy Of Aeronautics Inc · Stanford, CAN53065Cherry Hill Aviation LLC · Freetown, INN53068Legends Air Center LLC · Bentonville, ARN53069Northwoods Air LLC · Orono, MEN5306CSo Cal Leasing LLC · El Cajon, CAN5306EN5306e LLC · Ashburn, VAN5306GArno Christopher S · Dover Foxcroft, MEN5306KMills Bradley W · Wichita Falls, TXN5306LRusch Steven A · Sequim, WAN5306RSheldon Scott H · Cohasset, MAN5306UAircraft Solutions Group LLC · Englewood, CON53070Wnc Aviation LLC · Arden, NCN53077Megasky Holdings LLC · Charleston, SCN53078Proodian Kevin J · Wellington, FLN5307BHunter Warren M · Rainelle, WVN5307EHutton Douglas F · Elk City, OKN5307GBogen Alfred T III · Brandon, MSN5307PDaniels Kevin · Bellingham, MAN5307WWiley James E · Peace Valley, MON53083Clearwater Potlatch Timber Protect · Orofino, IDN53087Colorado North Western Community College · Rangely, CON5308GEast Iowa Air Inc · Bennett, IAN5308LNelson John · Wichita, KSN5308PRegistered aircraftN53092Reilly Patrick M · Anchorage, AKN5309BKadlubowski Michael J · Colorado Springs, CON5309DPotter John · Payson, UTN5309GMarshall Randall · Addison, TXN5309JRegistered aircraftRegistration pending, pending cancellationN5309LTexasflight3000 Holdings LLC · Crossroads, TXN5309PJabalera Josh M · Billings, MTN5309VFlight Training Aircraft LLC · Wilmington, DEN530AUWateractive43 LLC · Auburn, CAN530BWWhitehead William C · Mills River, NCN530CContinental Title Trust LLC Trustee · Wichita, KSN530CFFitzgerald Carson W · Mckinney, TXN530CJMyers Russell S · Spangle, WAN530ESki N Sky LLC · Leesburg, VAN530ERZima Aviation LLC · Huntington, CAN530GGSmith Jason · Calliham, TXN530HSCti Aircraft Leasing LLC · Memphis, TN
Back to AD 2007-04-19 R1