AD 2010-26-05 R1
Registered aircraft · 1,068
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:2010-26-05-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:2010-26-05-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:2010-26-05-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:2010-26-05-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.
N721FHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN722FSBank Of Utah Trustee · Salt Lake City, UTN722JBClos De Berry Leasing Ltd · New Carlisle, OHN725CJClub Jet Investments LLC · Wilmington, DEN725DMRhc Logistics Corp · Fostoria, OHFirst renewal noticeN729FSRegistration Pending · Oklahoma City, OKRegistration pendingN72PSCool Grove Equipment LLC · Fort Lauderdale, FLN72TVTvpx Trust Co LLC Trustee · North Salt Lake, UTN733AHumana Inc · Louisville, KYN733GBuzick Air LLC · Bardstown, KYN733HHumana Inc · Louisville, KYN733KHumana Inc · Louisville, KYN73FJTla73 LLC · Santa Rosa Beach, FLN73LRFalcon N73lr LLC · Belton, TXN744ARTop Air Texas LLC · Glendale, CAN745CXCdmorg Inc · Little Rock, ARN746ARJdm Aircraft LLC · Arlington, TXN748REHawk Air LLC · Waukegan, ILN748RMInterbank · Dover, DEN74XPN74xp LLC · Tualatin, ORN750JEJae Aviation LLC · Englewood, CON754JLNewport Blue LLC · Corona Del Mar, CAN754MMKings Aviation Corp · Garden City, NYN759QWorking Group LLC · Sarasota, FLN75ABRivers Equipment III LLC · Nashville, TNN75EKInto Air Aviation LLC · Clearwater, FLN75ENCsc Delaware Trust Co Trustee · Wilmington, DEN75KETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN7600GSas Institute Inc · Cary, NCN7600PSas Institute Inc · Cary, NCN7600SSas Institute Inc · Cary, NCN763PPTop Air Texas LLC · Glendale, CAN763UGray & Company Inc · Metairie, LAN767LDCaribbean Ops LLC · Dover, DEN767WBScandere LLC · Waukesha, WIN769JWRegistered aircraftN76BBank Of Utah Trustee · Salt Lake City, UTN76FDGrindstone Aviation LLC · New Castle, DEN770FGHangar LLC · Las Vegas, NVN771BVBbs I LLC · Vancouver, WAN771HMHmhc Inc · Plymouth Meeting, PAN774GHNext Generation Pdx LLC · Oregon City, ORN775GMGlobus Aviation LLC · Audubon, PAN775STDxp Holdings Inc · Houston, TXN777Erebus LLC · Tampa, FLN777FCAlghazzawi Hani · Holland, OHN777XYCair Leasing LLC · Wilmington, DEN77FWestrock Group LLC · Little Rock, ARN77METrilogy Investments Ag LLC · Las Vegas, NVN77QETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT
Back to AD 2010-26-05 R1