AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N5038RKnecht Ken L · Eagle River, AKN5038SRegistration Pending · Fort Worth, TXRegistration pendingN5038TBennett Howard N · Georgetown, KYN5038UButler Industries Inc · Amarillo, TXN5038WMarx Karl E · Juneau, AKN5038YAileron Buzz LLC · Daytona Beach, FLN50395Registered aircraftN50397Wright Preston T · Deeth, NVN5039DUp Above Ak LLC · Wasilla, AKN5039GPhronesis LLC · Tucson, AZN5039HBig Mountain Aviation Inc · Whitefish, MTN5039LGreyhawk Aviation LLC · Erie, CON5039NGutman Bradley J · Titusville, FLN5039RSmooth Landings Inc · Cary, ILN5039TMitchell Robert D · Freehold, NYN503AFAmerican Air Academy Inc · Merritt Island, FLN503AMAlpha Aviation LLC · Spartanburg, SCN503ATRegistered aircraftN503BNAllegrezza Fred · Line Lexington, PAN503CAThompson Paul W Jr · Yachats, ORN503CDLagade Marco C · Lake Mary, FLN503CPCivil Air Patrol · Maxwell Afb, ALN503DMLau Wolfgang · Cap Canaveral, FLN503DS503 Delta Sierra LLC · Silsbee, TXN503ETCarnahan Eric Q · Sardinia, OHN503GLWomack Thomas G · Lonoke, ARN503HVHelivision LLC · Concord, NCN503JSAlmont Orchards Inc · Chico, CAN503LWWechter William P · Ravenel, SCN503MAHobart Aviation Inc · Akron, OHN503MDChristy John R · Anchorage, AKN503MZWight Schuyler III · Goldsmith, TXN503PVMichaels Scott R · Saint Augustine, FLN503RAAirplanes And Coffee LLC · Kalispell, MTN503RFNovember Tango LLC · Richmond, VAN503RTPew Don E · Queen Creek, AZN503SBLeemon Ronald D · Prairie Du Sac, WIN503SPNew Horizon Aviation Inc · Warwick, RIN503STN503st LLC · Royal Oak, MIN503UAlba Leasing Services LLC · Scottsdale, AZN503WAThree Rivers Aero Inc · Three Rivers, MIN5040KRobinson Michael David · Folkston, GAN5040MHulme Aviation LLC · Gilbert, AZN5040POld Seale Properties LLC · Ft Mitchell, ALN5040RShirley Craig T · Ennis, MTN5040TGamblin Ryan · Perry, GAN5040UAir Data Solutions LLC · Natchitoches, LAN50412Ride The Kite LLC · Le Claire, IAN5041D5041 Delta LLC · Three Forks, MTN5041HSimplifly LLC · Mesa, AZ
Back to AD 2007-04-19 R1