AD 2000-05-20
Registered aircraft · 736
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:2000-05-20')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-05-20')
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:2000-05-20') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-05-20') 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.
N254FJAnthem Ventures LLC · Austin, TXN256VGitsis Nick Trustee · MakatiN25KZB & T Aviation USA LLC · Lakeland, FLN25MXAce Parts LLC · Santa Fe Springs, CAN25STLewis Garry L · Livingston, LAN25VRN25vr LLC · Portland, ORN261CHSeecon Builders Inc · Concord, CAN264CDf 254 Holdings LLC · Wilmington, DEN264RVHfa Specialty Acquisitions LLC · Boca Raton, FLN265HTmfb Transporation LLC · Orlando, FLN26NJAlliance Aviation Group LLC · Wilmington, DEN26SMTricor Aviation LLC · Winter Park, FLN270MFBank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeN271ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN272DNDel Mar College · Corpus Christi, TXN273LXFrist Aviation LLC · Nashville, TNN274SGFree Bird Flight Ops LLC · Newport Beach, CAN277XXBank Of Utah Trustee · Salt Lake City, UTN278GHTdsair LLC · Fishers, INN278RFGlenbrook III LLC · San Jose, CAN27AFAir4 Aviation LLC · Houston, TXN280BDLcg Enterprises LLC · Greenwich, CTN281QSSale Reported · Wilmington, DESale reportedN281SCFreedom Rising LLC · Corona, CAN2828Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN282TRed Star Aero Holdings LLC · Lewes, DEN283SADodson International Parts Inc · Rantoul, KSN285KKHaystack 204 LLC · Portland, ORN286CXPinnacle Assurance LLC · Tampa, FLN286MJHc Logistics LLC · Chicago, ILN288FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN28DCMbogo Energy LLC · Boerne, TXN291BBattelle Memorial Institute · Columbus, OHN291MJTequila Mockingbird LLC · New York, NYN298RDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN299FGTvpx Trust Co LLC Trustee · North Salt Lake, UTN299PRMeregrass Inc · Dublin, TXN29BBattelle Memorial Institute · Columbus, OHN2NLCenturion Investments Inc · Chesterfield, MON301AFAir4 Aviation LLC · Houston, TXN304KSonic Automotive Inc · Charlotte, NCN306BHSdy Leasing LLC · Waterford, MIN306SHN306sh LLC · Chicago, ILN30HQLearjet Inc · Wichita, KSN30TEV1vr LLC · Wilmington, DEN310ZAZair Force One LLC · Mendenhall, MSN311BPWls Enterprise LLC · Portland, ORN311KBJet Plaid LLC · Nashville, TNN312SHRegistered aircraftN313JLJnl Equipment Leasing LLC · Camden, DE
Back to AD 2000-05-20