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.
N419DHAerial Applicators Of Missouri LLC · Qulin, MON420AEAir Evac Ems Inc · O Fallon, MON420RLBlue Sky Leasing Inc · Delta, CON4227EMonarch Enterprises Inc · Kirkland, WAN422AEAir Evac Ems Inc · O Fallon, MON423AEAir Evac Ems Inc · O Fallon, MON424AEAir Evac Ems Inc · O Fallon, MON426AEAir Evac Ems Inc · O Fallon, MON4282ZSayre Stanley · Mantua, OHN429AEAir Evac Ems Inc · O Fallon, MON429ZACoastal Air Service Inc · Panama City, FLN42FOchoco Wood Products LLC · Prineville, ORN42SLHelicopters Inc · Wilmington, DEN430AEAir Evac Ems Inc · O Fallon, MON431AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN4338DAce High Helos LLC · Louise, TXN434AEAir Evac Ems Inc · Lewisville, TXN435AEAir Evac Ems Inc · O Fallon, MON436AEAir Evac Ems Inc · O Fallon, MON437AEAir Evac Ems Inc · Lewisville, TXN438AEAir Evac Ems Inc · O Fallon, MON43AEAir Evac Ems Inc · O Fallon, MON43EEHelicopters Inc · Wilmington, DEN440AEAir Evac Ems Inc · O Fallon, MON444AEAir Evac Ems Inc · O Fallon, MON445AEAir Evac Ems Inc · O'Fallon, MON446JBFinish Line Aviation LLC · Pembroke, NHN447AEAir Evac Ems Inc · O Fallon, MON447JBJbi South Leasing LLC · Pembroke, NHN449EAEdgefield Aviation LLC · Sandy, ORN453RRJetbird Aviation LLC · Conroe, TXN454AEAir Evac Ems Inc · O Fallon, MON460AEAir Evac Ems Inc · O Fallon, MON461RARanger Aviation Leasing LLC · Wilmington, DEN464AEAir Evac Ems Inc · O Fallon, MON465AEAir Evac Ems Inc · O Fallon, MON467AEAir Evac Ems Inc · O Fallon, MON468RLMarks Lloyd L · Lafayette, LAN469AEAir Evac Ems Inc · O Fallon, MON4717WSeven Whiskey LLC · Austin, TXN471AEAir Evac Ems Inc · O Fallon, MON473AEAir Evac Ems Inc · O Fallon, MON477SDHigh-Lead Helicopters LLC · Mossyrock, WAN479AEAir Evac Ems Inc · O Fallon, MON481RCOrange County Sheriff'S Office · Orlando, FLN482TJSky Aviation Corp · Worland, WYN4833Gm Leasing Co LLC · Broussard, LAN483AEAir Evac Ems Inc · O Fallon, MON4846G M Leasing Co LLC · Broussard, LAN484AEAir Evac Ems Inc · O Fallon, MO
Back to AD 2002-25-07