AD 2000-23-21
Registered aircraft · 47,138
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-21')
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-21')
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-21') 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-21') 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.
N2501SGonzales Gerald · Dallas, TXN2501XRoth Douglas K · Anchorage, AKN2502QMaxim Aviation LLC · Sugarloaf Key, FLN2502RLovell John W · Sherborn, MAN2502TLert Peter S · Graton, CAN2503RNicoliei Paul · Ione, CAN2503TLarue Mark C · Leander, TXN2503XDm Aviation LLC · Lexington, SCN2504RJht Aviation LLC · Longview, TXN2504TColumbia N2504t LLC · North Easton, MAN2504XInspire Technologies Inc · Caldwell, IDN2505JHarrah Enterprises LLC · Cornelius, NCN2505XGaviaire Aviation LLC · El Reno, OKN2506Cessna N2506 LLC · Doral, FLN2506QJohnson Jason D · Doniphan, MON2506TTango LLC · Anchorage, AKN2506XBaumberger Gene C · Greenville, ILN2507GBanks Gary M Jr Trustee · Scituate, MAN2507JDarter Lloyd R · Mountain Grove, MON2507LSimply Southern N2507l LLC · Fayetteville, GAN2507RKandle Sherry A · Boise, IDN2507SFriedman Jeffrey C Trustee · Oakland, CAN2508GBig Well Flying Club Inc · Kinsley, KSN2508RBrodt Gregory L · Chetek, WIN2508SErnst Don A · San Luis Obispo, CAN2508XCaspaar Valentin · Seattle, WAN2509KHolcomb John R · Siloam Springs, ARN2509TFarah Gregory · Meredith, NHN2509WDouble D'S LLC · Massillon, OHN250BWHawk Aviation LLC · Medford, ORN250CKCirrus Sr22 3421 Inc Owner Trustee · Wilmington, DEN250CW250 Charlie Whiskey LLC · Topeka, KSN250DCHightower George Jr · Thomaston, GAN250FBishop Thomas W · Decatur, TXN250GWasalo And Luby Air LLC · La Fayette, GAN250GCCarroll James E Trustee · Newington, NHN250JHJh Diaries LLC · Dublin, OHN250MCErp Transportation LLC · New Hudson, MIN250MLAlpha Aero Repair LLC · Dousman, WIN250MMMone Forwarding Lc · Laredo, TXN250PWMdl Aviation LLC · Gilbert, AZN250SFDelta Alpha LLC · Afton, VAN250SMRkm Aviation LLC · Lexington, NCN250SRBackcountryaviation LLC · Scottsdale, AZN250SXHigh Clouds 22 LLC · Montgomery, TXN250YMyers Mark E · Rogers, ARN2510TN2510tango LLC · Corona, CAN2510YMiller Aviation LLC · Sedona, AZN2511DDfs2024 LLC · Edwards, CON2511GVan Bortel Aircraft Inc · Arlington, TX
Back to AD 2000-23-21