AD 2000-04-01
Registered aircraft · 5,676
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-04-01')
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-04-01')
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-04-01') 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-04-01') 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.
N1122TAircraft Solutions Group LLC · Englewood, CON1123FUrsus Air Services · Anchorage, AKN1127DWings Over Texas Holdings LLC · Denton, TXN1128WFlorida Department Of Law Enforcement · Tallahassee, FLN1129CLanier Equipment Leasing LLC · Gainesville, GAN1129KOrange County Flight Center Inc · Santa Ana, CAN112PFEastern Kentucky University · Richmond, KYN112PZSkymaxx Inc · Daytona Beach, FLN112SVGb Aviation Of Alabama LLC · Millry, ALN1132WC Flying K Aviation LLC · Savery, WYFirst renewal noticeN1132XWest Coast Equipment Leasing LLC · Englewood, CON11345Enviroplus Consulting Inc · Rosamond, CAN11379Bas Part Sales LLC · Greeley, CON113AKFlight Training Aircraft LLC · Wilmington, DEN113CPCivil Air Patrol · Maxwell Afb, ALN113KHTextron Aviation Inc · Wichita, KSN113PFPremier Flight Center LLC · Hartford, CTN113SVChristiansen Aviation LLC · Wilmington, DEN114FBFly Appleton LLC · Appleton, WIN114VKKennedy Virgil C DBA · San Marcos, TXN1152ZRainier Flight Service LLC · Renton, WAN1154GPlane Nonsense Inc · Middletown, DEN1154WAerosim Academy Inc · Sanford, FLN1155MLagasse Michael · Newburyport, MAN1155PN1155p Corp Trustee · Wilmington, DEN1157RSale Reported · Miami, FLSale reportedN1158QN1158q LLC · Palm City, FLN1158VAtp Aircraft 7 LLC · Wilmington, DEN1159KCavu Aero LLC · Marietta, GAN1159ZThunderfighter LLC · Englewood, CON115CPCivil Air Patrol · Maxwell Afb, ALN115FJFargo Jet Center LLC · Fargo, NDN115KSKent State University · Stow, OHN115LWCrest Airpark Inc · Kent, WAN115PFHigh Tech Metals Inc · Harrisburg, PAN115SV115sv LLC · Lamar, MON115TAAtp Aircraft 7 LLC · Wilmington, DEN11614Lewis University · Romeoville, ILN1165YUgly Johns Aircraft LLC · Afton, OKN1166WFlight Operations Aircraft LLC · Wilmington, DEN11682Jahawk Leasing LLC · Sugar Grove, ILN116JEAtp Aircraft 6 LLC · Wilmington, DEN116KSKent State University · Stow, OHN116MVWing And Rotor Transportation Holdings LLC · Morristown, NJN116VGBruns Phillip T · Shiro, TXN116WBDunch David J Trustee · Poland, OHN116WETextron Aviation Inc · Wichita, KSN116ZXVranjes Peter · Johnstown, CON1173XWnc Aviation LLC · Arden, NCN117KSKent State University · Stow, OH
Back to AD 2000-04-01