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.
N2702RBas Part Sales LLC · Greeley, CON2702VAtx Aero LLC · Austin, TXN2702WMedic Choppers LLC · Springdale, ARN27036Pace William Todd · Palmer, AKN2703DBowser William · Burns, KSN2703GNeese Michael W · Homer, AKN2703QEdwards Daniel M · Wendell, NCN2703RWorthington Gary M · West Berlin, NJN2703TChapman Daniel W · Soldotna, AKN2704FUltimate Aviation LLC · Philadelphia, PAN2704NKimberton Corp LLC · Phoenixville, PAN2704PBriggs Ralph H · Des Moines, IAN2704QWalker Dennis R · Anchorage, AKN2704RStratus Equity LLC · Helena, MTN2704SC&M Asset Management LLC · Owasso, OKN2704UMatheson Thomas Blair · Mandan, NDN2704WSpillman David T · Flagstaff, AZN2704XChumchal Kelly R · Wharton, TXN2705GTrojcak Frank W · San Antonio, TXN2705KRegistered aircraftN2705LLt Aviation LLC · Plattsmouth, NEN2705QAdkins Emily L · Statesville, NCN2705RCenterline Aviation LLC · Nolensville, TNN2705TP/T Flyers LLC · Hayes, VAN2705XShallow David M · Salmon, IDN2706AFlhs LLC · Cedar Park, TXN2706GBlack Deberah L Trustee · Las Vegas, NVN2706PFraser William G · Berkley, MAN2706TDodson Internarional Parts Inc · Rantoul, KSN2706WElliott Frank F · Mojave, CAN2707FMontgomery Robert · Casper, WYN2707GFluckey Gary T · Homer, AKN2707RCsc Delaware Trust Co Trustee · Wilmington, DEN2707WLund Tyler David · San Diego, CAN2708LRafter Jm Enterprises LLC · Swink, OKN2708QElkhorn Aviation Inc DBA · Baker City, ORN2708SQuiroga Herman R · Phoenix, AZN2708TCae Aviation LLC · Peshtigo, WIN2708YWings Aircraft LLC · New Richmond, WIN2709BA&R Investments Inc · Sylvania, OHN2709DKimball Albert · Mount Dora, FLN2709FArmentrout Billy W · Thomasville, NCN2709PRuble Marsha L · Aurora, ORN2709RSchultz Daniel A · Tipp City, OHN2709XCmvii LLC · Chugiak, AKN270ATsg Associates LLC · Stanley, NCN270AMCode 1 Flight Training LLC · Wills Point, TXN270CRemmick Darwin · Jamestown, NDN270CACivil Air Patrol · Maxwell Afb, ALN270CCEuro 2000 Inc · Merritt Island, FL
Back to AD 2007-04-19 R1