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.
N35577Griffin Terry R · Rock Hill, SCN35578Christiansen Aviation LLC · Wilmington, DEN3557KEastern Aeroworks LLC · Punxsutawney, PAN3557YNoble Stewart G · Reno, NVN35581N35581 LLC · Longview, TXN35586Smith John S · Easthampton, MAN3558EVisalia Flyers LLC · Visalia, CAN3558FPacific Rim Adventures Inc · Los Olivos, CAN3558PConly Vernon J · Lehigh Acres, FLN3558YRegistered aircraftN35590Bas Part Sales LLC · Greeley, CON3559DStuder Edward J · Ballinger, TXN3559HTipps Brandon · Shelbyville, TNN3559MMoyer Josiah E · Paradise, PAN3559RWest Indies Aviation Corp Trustee · Wilmington, DEN3559ULewis Tyler Dean · Bullard, TXN3559WSherlin Grover W · Garland, TXN3559XSpon Water Consulting LLC · South Beloit, ILN3559ZLapp Matthew J · Bonners Ferry, IDN355ABXin Han Aviation LLC · Atwater, CAN355ADSky West Aviation Inc Trustee · Albuquerque, NMN355AKAris Aviation Group LLC · Henderson, NVN355ASPollux Aviation Ltd · Wasilla, AKN355BGGrabhorn Bart · Scappoose, ORN355CBM S T S LLC · Moses Lake, WAN355CMHanson Hans E · Anchorage, AKFirst renewal noticeN355CPCivil Air Patrol · Maxwell Afb, ALN355DProfessional Training Aircraft LLC · Wilmington, DEN355DCRyan John T · Salina, KSN355DHDofka Martin F III · Wheeling, WVN355DJVerdoljak Corey A · Homer, AKN355GPersonal Aviation Inc · Poway, CAN355GRGilson Steve · Covington, LAN355GWValiair Lc Trustee · Casper, WYN355JDCrop Duster Steve Inc · Sheridan, WYN355JHEmm USA Inc · Lewes, DEN355JPBryant Bruce B · Raymond, KSN355LGLilienthal Michael · Las Vegas, NVN355MDelaware Trust Company Owner Trustee · Wilmington, DEN355MEBode Aviation Inc · Albuquerque, NMN355MKNorth Star Aviation Inc · Mankato, MNN355PTasaair LLC · Wellington, FLN355RKWithers Dennis L · Hillsboro, OHN355RLRegistered aircraftN355RVKoenig Ryan George · Hernando, MSN355SAReddy James N Trustee · Port Orange, FLN355SCSmith Loren D · Great Falls, MTN355SHGray David M · Albuquerque, NMN355SXScaled Composites LLC · Mojave, CAN355TAIsland Amphibs LLC · Fort Lauderdale, FLFirst renewal notice
Back to AD 2007-04-19 R1