AD 2000-23-52
Registered aircraft · 134
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-23-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-23-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-23-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-23-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.
N786RLGm Leasing Company LLC · Broussard, LAN787RLGm Leasing Company LLC · Broussard, LAN794PPhi Aviation LLC · Lafayette, LAN797PPhi Health LLC · Tempe, AZN7TPDt Connect II LLC · New York, NYN803SPma 1 LLC · Wilmington, DEN821SSFly Safe LLC · Wilmington, DEN844LCWarbirds-3 LLC · Kalispell, MTN8455Arrow Aviation Company LLC · Broussard, LAN849PBArrow Aviation Co LLC · Broussard, LAN861ALArrow Aviation Company LLC · Broussard, LAN865ALArrow Aviation Company LLC · Broussard, LAN866ALMar Aviation LLC · Tulsa, OKN868ALArrow Aviation Company LLC · Broussard, LAN883ALBristow US LLC · New Iberia, LAN891BGGm Leasing Co LLC · Broussard, LAN893BGBristow U S LLC · New Iberia, LAN896BGBristow U.S. LLC · New Iberia, LAN905RDBristow LLC · Lake Charles, LAN9082AArrow Aviation Co LLC · Broussard, LAN911BBBollinger Enterprises LLC · New Orleans, LAN913GRS-76 Parts LLC · Blauvelt, NYN913PBHealth Care District Of Palm Beach County · West Palm Beach, FLN914GRS-76 Parts LLC · Blauvelt, NYN91AEPerfect Agreements Leasing Inc · Trabuco Canyon, CAN926CFMontgomery Capital II Of Delaware LLC · Fort Washington, PAN927MSOnyx Aviation LLC · Needham, MAN9483Arrow Aviation Company LLC · Broussard, LAN969YCYonkers Contracting Company Inc · Yonkers, NYN96SPGeneral Industries LLC · Camden, NJN976ALBallard Aviation Inc · Newton, KSN982TSIslander Holdings Ltd · Fort Lauderdale, FLN983TSIslander Holdings Ltd · Fort Lauderdale, FLN98PCSouthern Company Services Inc · Birmingham, AL
Back to AD 2000-23-52