AD 2000-11-52
Registered aircraft · 153
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-11-52')
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-11-52')
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-11-52') 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-11-52') 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.
N5294AArrow Aviation Co LLC · Broussard, LAN5415XConnecticut Air And Space Center · Stratford, CTN547WMBristow LLC · Lake Charles, LAN548GBAviation Instrument Services Inc · Miami, FLN576DTArea 109 LLC · Brooklyn, NYN576VPN576vp LLC · Chino, CAN60609Turbines Ltd · West Point, NEN6061CTurbines Ltd · West Point, NEN614JCKnight Helo LLC · Wilmington, DEN61DJBlack Badge Aviation LLC · Carson City, NVN644LHBank Of Utah Trustee · Salt Lake City, UTN653LHBank Of Utah Trustee · Salt Lake City, UTN664BCFlow Line Transportation LLC · Dallas, TXN67MECas LLC · Longboat Key, FLN707DSCas LLC · Longboat Key, FLN709PPhi Health LLC · Tempe, AZN709UCArrow Aviation Co LLC · Broussard, LAN711DSPentair LLC · Palmetto, FLN718PPhi Aviation LLC · Lafayette, LAN725MFArrow Aviation Company LLC · Broussard, LAN725PPhi Aviation LLC · Lafayette, LAN7266KGulf Helicopters LLC · Santa Fe, TXN72EHHelinet Aviation Services LLC · Van Nuys, CAN745PPhi Aviation LLC · Lafayette, LAN751LLState Of Illinois · Springfield, ILN753PPhi Health LLC · Tempe, AZN754LArrow Aviation Co LLC · Broussard, LAN759PPhi Health LLC · Tempe, AZN760BGBristow U S LLC · New Iberia, LAN760GPIndustrial Integrity Solutions LLC · Ontario, CAN760JEIslander Holdings Ltd · Fort Lauderdale, FLN760PVSikorsky Aircraft Corp · Stratford, CTN761CGCoulson Aviation (USA) Inc · Portland, ORN761MHMansfield Heliflight Inc · Milton, VTN762MHGm Leasing Co LLC · Broussard, LAN763MHGm Leasing Co LLC · Broussard, LAN7644SIslander Holdings Ltd · Ft Lauderdale, FLN764AMNorth Flight Aero Med · Grand Rapids, MIN765MHGm Leasing Co LLC · Broussard, LAN768ALSikorsky Aircraft Corp · Stratford, CTN768AMSpectrum Health Hospitals · Grand Rapids, MIN768MHGm Leasing Co LLC · Broussard, LAN768SXRentco LLC · Deer Park, TXFirst renewal noticeN769MHGm Leasing Co LLC · Broussard, LAN769PPhi Aviation LLC · Lafayette, LAN76CGCsc Delaware Trust Co Trustee · Wilmington, DEN76DNFastboy Equipment LLC · Beasley, TXN76EXIsland Express Helicopters Inc · Henderson, NVN76FLHelinet Aviation Services LLC · Van Nuys, CAN76FXFlexjet Vertical Lift LLC · Stratford, CT
Back to AD 2000-11-52