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.
N40VXHarder Steven R Trustee · The Sea Ranch, CAN40VZJump Jet LLC · Fort Worth, TXN40WABergstedt Yvonne · Anchorage, AKN40WFGrennell Brian M · Euless, TXN40WNRider Rebecca L · Hyde Park, NYN40WTPritchett Thomas A · Covington, GAN40WYFlywerx LLC · Anchor Point, AKN40XEFly Diamond Da40 N40xe LLC · Kalispell, MTN40XPRegistration Pending · Dallas, TXRegistration pendingN40XSSasser F Michael · Cedar Park, TXN40YLMeggers Roger D · Baker, MTN40YRHelicopter Services LLC · Cheyenne, WYN410Pacific Islands Aviation LLC · Wilmington, DEN4100FGoldberg Mark · Massapequa Park, NYN4100PValley Flying LLC · Stuarts Draft, VAN4100YLofton Charles T · Georgetown, MNN4100ZMountain Escape LLC · Pullman, WAN4101JRichardson Howell · Gilbert, AZN4101PKnepp Terry Wayne · Montgomery, INN4101YBower Gary R · Miranda, SDN4102BLamay James R · Reno, NVN4102HForeman Guy W · Valparaiso, INN4102LWiplinger Robert D · Inver Grove Height, MNN4102PDoran Jeffrey T · Westerville, OHN4102SFlying Drahthaar LLC · Billings, MTN4103NKarpik Joseph Paul · Floodwood, MNN4103PLumley John J · Delray Beach, FLN4103SSky High Aviation LLC · Fishers, INN4104PSpooter Air II LLC · Willis, TXN4104SSky West Aviation Inc Trustee · Albuquerque, NMN4104T4a Legacy Enterprises LLC · Mcallen, TXN4104XBandy Carla Sr · Texarkana, TXN4104YBurgett Gary · Galena, AKN4104ZZelina William B III · Fort Greely, AKN4105CJohnson Rodney R · Roseburg, ORN4105HBonanza Valley Air LLC · Alexandria, MNN4105SAxis Aviation Group Inc · Sacramento, CAN4105YChock Steven Y H · Lopez Island, WAN4105ZMccaughey Steven A · Winter Haven, FLN4106CAir Data Solutions LLC · Natchitoches, LAN4106JFlander Donald D · What Cheer, IAN4106NGioia Matthew M · Stafford, VAN4106SCompnet Solutions Inc · Dallas, TXN4106XRossiter Andrew J · Vancouver, WAN4106ZJohnson Royce D · Clinton, ARN4107NWest Main Auto Sales Inc · Tupelo, MSN4107PTm Aero Marine Inc · North Miami, FLN4107SAnnamar LLC · Wilmington, DEN4107XRedsun Oren Daniel · Fairfield, CAN4107YJohnson Eric L Trustee · Valley, WA
Back to AD 2007-04-19 R1