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.
N2654ESch Aviation Inc Trustee · Sporle Kings LynnN2654FGregory Daniel · Virginia Beach, VAN2654PSamson Mason H · Rives Junction, MIN2654RFindarle John J · Midway, UTN2654YHolty Joseph G · Fairbanks, AKN2654ZAlbij3 LLC · Milton, FLN2655CSmith Lionel J · Ironton, MON2655GBeachy Benjamin D · Whittington, ILN2655QRedmond Angela L · Austin, TXN2655RBeck Bartholomew · Dry Ridge, KYN2656CHgta Partners LLC · Grand Rapids, MIN2656GAtp Aircraft 4 LLC · Wilmington, DEN2656KT And H Aircraft Leasing LLC · Yakutat, AKN2656QPankrate Kenneth W · Opheim, MTN2656REdex Aviation LLC · Sutter Creek, CAN2656SPierini William C · Chico, CAN2656TCardinal Point Aviation Services LLC · Homestead, FLN2656ZChesebro Brian S · Oro Valley, AZN2657FPoolshark Equipment LLC · Memphis, TNN2657MCurtis Christopher J · Wasilla, AKN2657WRegistered aircraftN2657YNagy Leslie S · Walnut Creek, CAN2658BBrowning Frank W · Port Orange, FLN2658CMay Jeffrey P · Seligman, AZN2658FClayton Alfred T · Anchorage, AKN2658GSauer Roger A · Glenburn, NDN2658RNorthern Science Services LLC · Anchorage, AKN2658TLoer Stanley W · Grants Pass, ORN2658WPerez Dennys · Orlando, FLN2658ZVirtue Genetics LLC · Cedar Rapids, IAN26595Levy Alfred E · Richardson, TXN2659BAnderson Brian E · York, PAN2659GMarmon David J · Great Falls, MTN2659KWickline Wayne · Flower Mound, TXN2659QMorrison Mark C · Marfa, TXN2659RBerrios Antonio · Genoa, ILN2659SRovey Gerald A · Troy, IDN2659UMec Management LLC · Wilmington, DEN2659WMooney Flyer LLC · Belton, SCN265AAWhitten Chris K · Alton, MON265ACMorgan Nigel · Asheville, NCN265ATAirline Transport Professionals Corp Of USA · Wilmington, DEN265BHillestad Darrell · Aberdeen, SDN265BSGrant Charles K · Topton, NCN265CAZacherl Randall L · Indiana, PAN265DBKlw Coastal Equipment LLC · Destin, FLN265DTLynn Daniel K · Beaverton, ORN265ERAerosolutions Group Inc · Wilmington, DEN265FAStratus Rr LLC · New Castle, DEN265HBBarrow Guy J · Loveland, CO
Back to AD 2007-04-19 R1