AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N6835KWill Robert I Jr · Shoreline, WAN6835NHirzel William J · Walbridge, OHN6835PMarvin Shawn · Tomahawk, WIN6835UBas Part Sales LLC · Greeley, CON6836BHowes Christopher T · Allardt, TNN6836KBundrant Wlliam D · Snellville, GAN6836UEllis Grover D · Sanford, NCN6836VHonaker Ronald R · Saint Louis, MON6837KHagglund Carl D · Pendleton, ORN6837NBloom Alexsandr · Westfield, MAN6837UJohnson Aviation LLC · West Lafayette, INN6838BMize Donnie Glenn · Pearland, TXN6838PHartley Victor A III · Woodbine, NJN6838UPethe Travis K · Littleton, CON6839PFriesen Brad A · Plains, TXN6839UEgbert Ryke Scott · Ogden, UTN683ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEN683CPCivil Air Patrol · Maxwell Afb, ALN683FLPuhalla Matthew C · Shelton, NEN683HBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN683JAYale Companies LLC DBA · Indianapolis, INN683LHChristiansen Aviation LLC · Wilmington, DEN683RUniversity Of North Dakota · Grand Forks, NDN683SHSouthern Utah University · Cedar City, UTN683SPNovember 243 Bravo Mike LLC · Castle Rock, CON68402Space Coast Aircraft Co · Merritt Island, FLN6840KValley Airways Inc · Scottsbluff, NEN6840NJohnston Robert M · Plantation, FLN68414Wright Duane C · Sanford, FLN68418Moore Michael P · Houston, TXN6841LSaglimbene Ronald · Wyckoff, NJN6841MGwiazdon Edward P · Lake Elmo, MNN6841WBoehm Darrell · Safford, AZN6842JOracle Aviation LLC · Omaha, NEN6842UThompson Matthew S · Fowler, CON6843HWhitefish Mountain Acft Rentals And Flt School LLC · Whitefish, MTN6843UBoone Joe · Madison, INN6843WRhodes Michael J · Fresno, CAN6844JHundshamer Sara M · Smithfield, UTN6844KNoguess Levi B · Belton, TXN6844ZAntelope Valley Soaring Club · Llano, CAN68459Airplanes And Helicopters Of Oregon LLC · Sisters, ORN6845BShrode Rafe C · Jewett, TXN6845KGottfried Virgil P · Wilkesboro, NCN6845NTriplett Jared · Mckinnon, WYN6845UTarrant James D · Wenatchee, WAN6845ZBr Trucking LLC · Cut Bank, MTN68460Registration Pending · Sheridan, WYRegistration pendingN6846NBitcertificates LLC · Kalispell, MTN6846UStokely Nicholas J · Wagram, NC
Back to AD 81-18-04 R2