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.
N4529RSulzby Ivan Gerardo · Las Vegas, NVN4529SRegistration Pending · Frisco, TXRegistration pendingN4529UDavis Jeremy S · Port Alsworth, AKN4529XRyan Flatt Cattle Co · Marfa, TXN4529YCunningham David L · Phoenix, AZN452AKSalo Mark W · Poulsbo, WAN452AMHedges Aviation Inc · Ronkonkoma, NYN452CWashington Derrick A · Louisville, KYN452CBCyrus Richard W · Salisbury, MDN452CPCivil Air Patrol · Montgomery, ALN452CTMain Rotor Enterprises Llp · Scottsville, KYN452DMH Grettum LLC · Lewes, DEN452EPRainier Flight Service LLC · Renton, WAN452FRBonanza Valley LLC · Reno, NVN452JPBrushpopper Aviation LLC · Annona, TXN452JSOffroad Aviation LLC · Las Vegas, NVN452KKramarich Kenneth · Wintersville, OHN452MEMagnum Leasing LLC · Waterford, MIN452PWDaniella Levi & Associates Pc · Fresh Meadows, NYN452RVNash Timothy E · Chesapeake Beach, MDN452SPhantom Aviation LLC · Portland, ORN452SCBond Jeffrey B · Lebanon, MON452SKAlcock Shane Vincent · Temple, TXN452SMChristiansen Aviation LLC · Wilmington, DEN452WWilder Scott J · Orinda, CAN45304Unruh Gerald R · Nampa, IDN4530BMichael Anna B · Daytona Beach, FLN4530DMccauley Terry D · Rogers, ARN4530EAig Aeronautics LLC · San Juan, PRN4530FBean David L · Chandler, AZN4530SMontague Ronnie L · French Camp, MSN4530TKoprivnik Anton J · Painesville, OHN4530VSaunders Christopher D · Lehighton, PAN4530YSchindler Rick M · Neligh, NEN45315Taylor Caleb H Trustee · Rancho Santa Fe, CAN45319Dale Timothy · Simsbury, CTN4531FOneill Robert J · Rocklin, CAN4531JQualitair LLC Trustee · MichelstadtN4531PDelta Sierra LLC · Naples, FLN4531SMajors Flying Club · Greenville, TXN4531ZFelts Jacob I · Kalispell, MTN45322Alvord Scott Richard · Yorba Linda, CAN45329Marino Jack C Sr · Gause, TXN4532ARasmussen Duane T · Culbertson, MTN4532BSpeedbird Ventures LLC · Driftwood, TXN4532JCohen Kyle Lee · Houston, TXN4532KFranklin Paul A · Independence, ORN4532NSkytypers Inc DBA · Las Vegas, NVN4532PMorowitz Jeremy T · Greenwich, CTN4532RWherley Matthew J · Plato, MN
Back to AD 2007-04-19 R1