AD 2002-25-07
Registered aircraft · 542
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:2002-25-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-25-07')
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:2002-25-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-25-07') 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.
N486AEAir Evac Ems Inc · O Fallon, MON48AEAir Evac Ems Inc · O Fallon, MON490AEAir Evac Ems Inc · O Fallon, MOFirst renewal noticeN49MAAv8-Orr Helicopter Services Inc · Hamilton, MTN4CQHelicopters Inc · Cahokia, ILN4KAAmbrose Group Inc · Bellevue, WAN5000BAir Flite Inc · Shawnee, OKN5000GTimberland Helicopters Inc · Ashland, ORN50046Orlando Aircraft Sales LLC · Orlando, FLN5007FPatriot Aviation Inc · Greenville, DENon-citizen corporation, flight hours not reportedN5013GHmc Lift LLC · Wilmington, DEN5017GHelimontana.Com LLC · Livingston, MTN505RLOrgis Bj · Hallettsville, TXN514RLSlikker Flying Service Inc · Buttonwillow, CAN516LERotor Republic LLC · Orlando, FLN520RLPremier Rotors LLC · Saint Martinville, LAN523RLLarson Helicopters LLC · Perham, MNN523TDTvpx Ars Inc Trustee · North Salt Lake, UTN52AEAir Evac Ems Inc · O Fallon, MON52GHPleasant Gap Land Co Inc · State College, PAN52PLParatus Air DBA · Auburn, INN53702Helicopter Applicators Inc · Gettysburg, PAN538TDEl Destino LLC · Monticello, FLN539AEAir Evac Ems Inc · O Fallon, MON53AEAir Evac Ems Inc · O Fallon, MON545SAShier Aviation Corp · San Diego, CAN547AEAir Evac Ems Inc · O Fallon, MON54AEAir Evac Ems Inc · O Fallon, MON54NYWisk Aero LLC · Mountain View, CAN54SPIndiana State Police · Indianapolis, INN552AEAir Evac Ems Inc · O Fallon, MON553AEAir Evac Ems Inc · O Fallon, MON558AEAir Evac Ems Inc · O Fallon, MON559AEAir Evac Ems Inc · O'Fallon, MON55SLHelicopters Inc · Cahokia, ILN560PK&D Aviation LLC · Kingston, OKN563AEAir Evac Ems Inc · O Fallon, MON566AFRickards Aviation Group LLC · Dagsboro, DEN56757Jbi South Leasing LLC · Pembroke, NHN567AEAir Evac Ems Inc · O Fallon, MON569THelicopters Inc · Wilmington, DEN570JHHarnden Aviation Group LLC · Harrisburg, PAN570KDK&D Aviation LLC · Kingston, OKN570LEHhl LLC · Denver, CON570RLJasons Helicopter Services · New Prague, MNN571CJRotorpro LLC · Sevierville, TNN57441Jbi South Leasing LLC · Pembroke, NHN5745YMonarch Enterprises Inc · Kirkland, WAN57491Monarch Enterprises Inc · Kirkland, WAN574AEAir Evac Ems Inc · O Fallon, MO
Back to AD 2002-25-07