AD 48-07-01
Registered aircraft · 2,265
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:48-07-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:48-07-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:48-07-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:48-07-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.
N140KYCarpenter Michael A · Jefferson, ORN140LBBerry Brian R · Tahlequah, OKN140LDMazankowski Lara R · San Diego, CAN140MENorah Bridget · Snoqualmie, WAN140MTHoover Josiah E · Wasilla, AKN140MWWeyant Charles B · Santa Maria, CAN140NJames Justin C · Pima, AZN140NSSwann Neal P · Plymouth, CAN140PClass A Coaches LLC · Missoula, MTN140PRBlue Sky Air LLC · Queen Creek, AZN140QSchroeder Peter G · Clemmons, NCN140SGGault Scott J · Norcross, GAN140SKRon Alexander Youth Aviation Program · Williamson, GAN140TGRounds Chris · Waller, TXN140TJSetter Thomas D · Burnsville, MNN140TMKauffman Marvin Paul · Brooksville, MSN140TWRegistration Pending · Burlington, NCRegistration pending, pending cancellationN140VMaggart Daniel J · Winchester, ILN140WYWilson J Brent Trustee · Lander, WYN140XRegistration Pending · Scottsbluff, NERegistration pendingN140YABeineke Paul R · Marion, OHN146FTTavener Frederick L · Cape May, NJN146VSchmidt Aaron Joseph · Bisbee, AZN149JASummers Dennis L · Perry, OKN1508UKnefley J Michael · Ulysses, PAN150RBailey Richard N · Danville, VAN154DGFisher Jeffrey L · Thorndale, TXN1600KDenzil Charles David · Southmayd, TXN1601VIte LLC · St Pete Beach, FLN1604VShuel Dale W · Brighton, CON1605VLindsey Allie Ayers · Lamont, OKN1606VWeatherproof Montana LLC · Missoula, MTN1610VSale Reported · Lisbon, OHSale reportedN1611VRevak Ben · Dousman, WIN1612VQuan Justin · Ventura, CAN1619VCushway Amos · Anchorage, AKN1624VSmith John C · Greenville, NCN1627VSmith Eric M · Sanger, TXFirst renewal noticeN1630VBaeseman Alex J · Moab, UTN1636VMoeser David P · Colton, ORN1645VBode Theodore Wayne · Potosi, WIN1646VTodd Doug A · De Witt, IAN1649VLaforce Larry B · Big Sandy, TXN1651VKistler Harvey S · Colby, KSN1656VCobb Raymond E · Highland, CAN1661VWeggel Roger · Fairbanks, AKN1662VLauer Donald Robert · Prospect, OHN1663VBryant George R · Gainesville, TXN1670VHale Justin A · Cheyenne, WYN1671VHarris James J · Saint Marys, OH
Back to AD 48-07-01